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

Importing Data from File (CSV file with Pipe Delimited) into Table

回答済み
デモをリクエスト

Hi Team,

 

Thank you for all your support.

 

I have a task to load File data into Table where in basically File is CSV file delimited with Pipe and Table scheme also created according to delimiter being used.

 

If I tried to load this File into table manually in Wdata it did worked as I have the option to select the "Delimiter" while adding dataset.

 

However while performing this with Chain, using "Import file into Table" command, its throwing "No matching columns" error while data import.

 

Kindly help.

 

Thanks,

Madhuri Desai.

0

コメント

1件のコメント

日付 投票
  • Jeff Hickey

    Hi Madhuri Desai. Prior to uploading the file in Chains, have you tried using the Change Delimiter command to change it to either comma or tab delimited? If the first row in the file doesn't match the schema of the column IDs in the table, you may also need to either add in the header row and/or map the headers at the import step.

    0

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