クラシックファイルタイプは2021年1月をもって使用できなくなりました。クラシックファイルを移行することも、PDFをダウンロードすることもできます。詳細はこちら

create file command- explicit delimiter

回答済み
0

コメント

4件のコメント

  • 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

サインインしてコメントを残してください。