I am reading in a .ndjson file into alteryx but somehow only the first row is read in. Can anyone help me how to read in the full file? Thank you.
Can you post sample data - This looks pretty normal from your screen grabs. I assume you are saying that only the first JSON entry is
being read in - but I can't see anything wrong.
Unfortunately, I cant post the sample data as it contains sensible personal information. And yes, only the first entry is read in, the rest is missing in the data. Could it be because my file is of the type .ndjson but alteryx can also read in .json?
highly unlikely. This looks like the input data has 29 records (json value entries). These are show in the input data and the browse tool. My assumption is this is one Json record with 29 fields. Try posting the config of your json parse tool - but I'd suggest opening the .ndjson file in notepad and seeing how many entries there are..