Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Check out our powerful new search update! You can read more here. Please let us know if you have any feedback by creating a topic here.

Load extremely large Json file



I'm trying to load a large Json file that's about 100MB in size, but for some reason it only reads about 4% of the total data giving me a few thousand records.

Is there a limit to the size of Json file that Alteryx reads or just the way the file was encoded?

For example the encoding methodology could set up any breaks within the dataset?


Due to the size of the data, it cant be read as a csv file.

But when I ran a smaller dataset, reading as csv format gives 8,031 records whereas input as a json file gives me straight 5,155 records (shown in screenshot).

Maybe some python script to read json file would help too?


Any idea would be very much appreciated, Thanks



Hi Parisli,


This post will help.


Simple tool that works with Designer using a free macro, handles any size JSON data set very easily.