Reading JSON file off desktop stops at 104 records?

I have a very large JSON file that I'm trying to parse out. The file is over 7,000 lines when opened in notepad. I've tried a few methods to get this into designer and parse it out but it keeps limiting what's input to 104 records as shown below. What am I doing wrong here or is there some limitation I don't know about?

Parse

MongoDB

Accepted answers

CharlieS

Hmm. the next step I'd recommend is reading as just text into Alteryx and using other tools to parse out the data you need. Try setting the file type to CSV and setting a delimiter of "\0" (which means none). So now all the text will be input and try the JSON Parse tool, or other parse tools.

Also, if this is a file/sample you can share, I'm sure the Community would take a crack.

All comments

CharlieS

HI @merrij

Have you tried checking the "Search SubDirs" box? Perhaps those additional values are stored at a sub directory level.

merrij

Hi CharlieS, I just tried that. Still getting the same 104 results.

CharlieS

Also, if this is a file/sample you can share, I'm sure the Community would take a crack.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703