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!
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
Hi @Sophaloaf2010
You can read the file, as below.
Hope it helps!!!!
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.
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?
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
You can remove the record ID tool based on your business need.
You cant drag and drop.
Please use the below setting to achieve reading the .ndjson file
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.
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.
There you go, does this help?
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
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
@Sophaloaf2010
If possible can you add the file you are trying to use as the input
I will try from my end please.
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!!!
