Big text input file

[nako92]

Hello everyone,

I have a json text file which I want to process in Alteryx. Alteryx sees all data as one record in one string fileld. 

The problem is that the file contains 33,000 characters. In alteryx when I use "Flat ASCII file" as an input type, the maximal number of characters in one field of this kind is 6500. I do not know what type of input should I use or maybe I should do it in some other way.

Could you help me with getting this json file into alteryx? 

I would be grateful!

Best regards

[MarqueeCrew · Accepted solution]

Please try csv with \0 as a delimiter. 

[nako92]

Thank you very much!

It works perfectly.

[stephenweiss0]

Is there a solution if I don't have a CSV version? My JSON is in a postgres database and I have an ODBC.

[sahartz]

Hi @MarqueeCrew I have 20 txt files that I need to input. Is there a way to define your solution in 1 time or do I need to go file by file?