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!

[ShankerV]

Hi @Sophaloaf2010 

Please replace this filename with your filename which you need to read.

Kindly keep the workflow in the same path of the input file as I have used .\ where I have kept the input file and workflow in the same path.

Kindly let me know if you have more questions.

Many thanks

Shanker V

[Sophaloaf2010]

Hi, I have tried as you explained and put the file and the workflow in the same path and replaced the name of the file with my filename. It still does not work as the Error "Can't find the file" comes up, although they are both in the same path.

[ShankerV]

Hi @Sophaloaf2010 

Can you please share the error screenshot

Also the input tool configuration too..

[Sophaloaf2010]

There you go, does this help?

[ShankerV]

Hi @Sophaloaf2010 

I see you have have used a complete total different format.

Please remove the .yxdb highlighted in red.

Then change the yellow highlighted one to .csv

[Sophaloaf2010]

I still get the same error unfortunately.

[ShankerV]

Hi @Sophaloaf2010 

Please do the below 2 modification.

I see the filename has two fullstop. 

Rename the file name as so simple like a.ndjson to import for testing purpose.

Also please make sure the below setting as CSV format.

Thanks a lot in advance.

[Sophaloaf2010]

I renamed the file but I could not change the input parameters of "Delimiters" and "Field Length", as Alteryx does not let me. Same error comes up now

[ShankerV]

@Sophaloaf2010 

If possible can you add the file you are trying to use as the input

I will try from my end please.

Many thanks

Shanker V

[Sophaloaf2010]

Unfortunately the file contains sensitive/personl data which I cannot share. If there is no other way I will try to convert the input format somehow to a normal .JSON format and try to import that.

Thank you very much for your help though!!!