Classic file types are no longer available for use as of January 2021. You can transition your classic files or download a PDF. Learn More

create file command- explicit delimiter

Comments

4 comments

  • Jeff Hickey

    Hello Ganesh, you can use the Tabular Transformation command Change delimiter to make the delimiter comma or tab separated. Encapsulating the data in double quotes will allow you to include commas in your data. For example: "this, is, cell, A1","this, is, cell, A2". The file you upload to a Wdata Table must be either comma separated (.CSV) or tab separated (.TSV). For reference, this requirement is documented at https://support.workiva.com/hc/en-us/articles/360036003291-Wdata-feature-and-API-limits#section1.

    0
  • Ganesh Karri

    Thanks Jeff. is there a way to encapsulate double quotes within wdata instead of requesting the source to encapsulate?

    0
  • Jeff Hickey

    Hi Ganesh, the Change delimiter command will encapsulate the data for you as long as your source file is well formed. For example, if your file is pipe delimited it may look like this: this, is, cell A1|this, is, cell, A2. After running it through Change delimiter, the result would be: "this, is, cell, A1","this, is, cell, A2".

    0
  • Ganesh Karri

    Thanks Jeff. this is very helpful

    0

Please sign in to leave a comment.