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

Highlighted
Atom

Hi

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

 

Alteryx
Alteryx
Highlighted
Meteor

Hi Parisli,

 

This post will help. 

 

https://community.alteryx.com/t5/Analytics-Blog/SlamData-Alteryx-A-Slam-Dunk-Analytics-Partnership/b...

 

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

 

Jeff

 

 

Labels