Klasyczne typy plików nie są już dostępne od stycznia 2021 r. Możesz przenieść swoje klasyczne pliki lub pobrać plik PDF. Dowiedz się więcej

Importing Data from Tab Delimited File CSV file into Table

Udzielono odpowiedzi
Zamów wersję demonstracyjną

I am getting "No Matching Columns" error on File Import step in Chain.

The file is Tab delimited. I can't convert it to comma delimited as some of the column values have comma as a valid value.

FYI. I am successfully able to load the file manually in the same table (because I believe during manual import, we have to manually select the delimiter). 

How can I make this work now?

 

0

Komentarze

Komentarze: 2

Data Głosy
  • Jeff Hickey

    Hi Rahul,

    The Create File command requires the file is comma separated or JSON. Use the Tabular Transformation command Change Delimiter to change the delimiter of your file from tab to comma. Then use this new file with the updated delimiter in the Create File step.

    If your data includes a comma in it, you can wrap the data in double quotes such as "this, data, has, commas" to keep all of this data in a single cell. The Change Delimiter command will handle this formatting for you.

    0
  • Rahul Patel

    Using “Change Delimiter” option from Tabular Transformation (Right before File load step) helped resolve this issue.

    Thank you Jeff Hickey for your suggestion. Really appreciate it !!

    0

Zaloguj się, aby dodać komentarz.