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

[Harshitratd]

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.

[Carlithian]

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. 

[ahsanaali]

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