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
Solved! Go to Solution.
Please try csv with \0 as a delimiter.
Thank you very much!
It works perfectly.
Is there a solution if I don't have a CSV version? My JSON is in a postgres database and I have an ODBC.
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?