Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Only first row of .ndjson file is read into alteryx

Sophaloaf2010
7 - Meteor

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.

 

Sophaloaf2010_0-1675956646393.png

 

3 REPLIES 3
apathetichell
19 - Altair

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.

Sophaloaf2010
7 - Meteor

@apathetichell 

 

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?

apathetichell
19 - Altair

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..

Labels