topic Re: How to import .NDJSON file into Alteryx Designer in Alteryx Designer Desktop Discussions

How to import .NDJSON file into Alteryx Designer

Sophaloaf2010 — Fri, 27 Jan 2023 10:24:07 GMT

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!

Re: How to import .NDJSON file into Alteryx Designer

Deano478 — Fri, 27 Jan 2023 10:31:57 GMT

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

Re: How to import .NDJSON file into Alteryx Designer

ShankerV — Fri, 27 Jan 2023 10:33:44 GMT

Hi @Sophaloaf2010

You can read the file, as below.

Hope it helps!!!!

Re: How to import .NDJSON file into Alteryx Designer

Sophaloaf2010 — Fri, 27 Jan 2023 10:49:24 GMT

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.

Re: How to import .NDJSON file into Alteryx Designer

Sophaloaf2010 — Fri, 27 Jan 2023 10:53:25 GMT

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?

Re: How to import .NDJSON file into Alteryx Designer

ShankerV — Fri, 27 Jan 2023 10:59:26 GMT

Hi @Sophaloaf2010

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

Many thanks

Shanker V

Re: How to import .NDJSON file into Alteryx Designer

ShankerV — Fri, 27 Jan 2023 10:58:32 GMT

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

Re: How to import .NDJSON file into Alteryx Designer

Sophaloaf2010 — Fri, 27 Jan 2023 11:00:34 GMT

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.

Re: How to import .NDJSON file into Alteryx Designer

ShankerV — Fri, 27 Jan 2023 11:01:20 GMT

Hi @Sophaloaf2010

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

Many thanks

Shanker V

Re: How to import .NDJSON file into Alteryx Designer

ShankerV — Fri, 27 Jan 2023 11:04:56 GMT

Hi @Sophaloaf2010

You cant drag and drop.

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

Re: How to import .NDJSON file into Alteryx Designer

ShankerV — Fri, 27 Jan 2023 11:10:13 GMT

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

Re: How to import .NDJSON file into Alteryx Designer

Sophaloaf2010 — Fri, 27 Jan 2023 11:59:04 GMT

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.

Re: How to import .NDJSON file into Alteryx Designer

ShankerV — Fri, 27 Jan 2023 12:00:18 GMT

Hi @Sophaloaf2010

Can you please share the error screenshot

Also the input tool configuration too..

Re: How to import .NDJSON file into Alteryx Designer

Sophaloaf2010 — Fri, 27 Jan 2023 12:41:17 GMT

There you go, does this help?

Re: How to import .NDJSON file into Alteryx Designer

ShankerV — Fri, 27 Jan 2023 12:44:05 GMT

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

Re: How to import .NDJSON file into Alteryx Designer

Sophaloaf2010 — Fri, 27 Jan 2023 12:49:43 GMT

I still get the same error unfortunately.

Re: How to import .NDJSON file into Alteryx Designer

ShankerV — Fri, 27 Jan 2023 12:54:49 GMT

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.

Re: How to import .NDJSON file into Alteryx Designer

Sophaloaf2010 — Fri, 27 Jan 2023 13:00:50 GMT

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

Re: How to import .NDJSON file into Alteryx Designer

ShankerV — Fri, 27 Jan 2023 13:02:43 GMT

@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

Re: How to import .NDJSON file into Alteryx Designer

Sophaloaf2010 — Fri, 27 Jan 2023 13:23:22 GMT

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