CSV imports fail..

Question

Hi All,Still a beginner here.. I have a CSV file to import but unlike other CSV files I imported for other workflows, this one only imported as only one column.  The file was long and big (A all the way to AZ - I cut off most columns for sample file), but I feel it's the delimiter issue -- yet I pretty much tried everything I could and still couldn't make it to work.

Anyone may take a look at my sample file and workflow please?

Thanks a lot!

MTG - 240 Active Extract 20210904.csv

Sample CSV import.yxmd

cmcclellan · Accepted Answer

Technically it's not a CSV, it's a TSV (Tab Separate Volume)

In the Input data tool change the Delimiter to this:

and it will work