How to import .NDJSON file into Alteryx Designer

[Sophaloaf2010]

I have a large .ndjson file that I want to import but the file does not show up in the "Input Data" node. Any ideas why or how to fix it? Thank you!

[Deano478]

Hey @Sophaloaf2010  You might find this link useful it shows you all of the supported files types in Altyerx & what to do with Unknown files types:

https://help.alteryx.com/20223/designer/input-data-tool 

[ShankerV]

Hi @Sophaloaf2010 

You can read the file, as below.

Hope it helps!!!!

[Sophaloaf2010]

Hi, 

Thank you for your replay - however the file you are importing here is a .JSON, not a .NDJSON. My file does not show up when I use the usual import node.

[Sophaloaf2010]

Hey, Thank you for your reply. I can't find the section where it says how to deal with unkown formats. .NDJSON is not listed as an accepted format, any idea what I can do to import it somehow?

[ShankerV]

Hi @Sophaloaf2010 

Please find the below where we can read .ndjson file too

Many thanks

Shanker V

[ShankerV]

Hi @Sophaloaf2010 

I have used a sample .ndjson file with just 5 rows.

It will also read huge files, hence added the Record ID tool to read the line number. 

Then used the JSON Field tool to split.

Many thanks

Shanker V

[Sophaloaf2010]

Hi, so you are able to read in .NDJSON files? For me it does not show up as a viable format and I can't drag and drop the files in the input node. Is there a specific Add-in I might need? I have the latest version of Alteryx Designer.

[ShankerV]

Hi @Sophaloaf2010 

You can remove the record ID tool based on your business need.

Many thanks

Shanker V

[ShankerV]

Hi @Sophaloaf2010 

You cant drag and drop.

Please use the below setting to achieve reading the .ndjson file