Challenge with csv file (400+ columns) - Tools are not able to read the columns

Question

Hello Team,

I'm encountering a problem with a csv file in which the column count exceeds 400. While I can successfully read the file, I'm unable to view the lost of fields when I connect tools like select or filter and because of this i am not able to build the workflow. Would really appreciate your help on this one.

Capture.PNG

ahsanaali · Answer

Unless you need all 400 columns, try limiting the number of columns with Dyanmic Select tool.

Carlithian · Answer

Hey @Harshitratd

I would possibly try importing the data with a different delimiter, so if it is currently a comma, perhaps use \0, you will need to greatly increase the string length and the aim is for all the data to come in in a single column. Then attempt to parse the data within Alteryx.