Alteryx Designer Desktop Discussions

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

Reading in .JSONL File in Designer

Siddhant_Surve
6 - Meteoroid

Hello Community,

 

Could anyone please describe a way to read in a .JSONL file in designer ? 

 

Siddhant_Surve_0-1624212756951.png

3 REPLIES 3
apathetichell
19 - Altair

Not sure if you were trying to include an attachment - but there's only a picture of your filename. Input data - load  your file as a .csv (note you'll have to choose your file manually since .jsonl isn't immediately found)... use /n as a delimter - fist row contains data(if it does) and increase the field length as  needed...

 

this give you useable data and you manually divy it up as you want or attach a Json Parse tool.

Siddhant_Surve
6 - Meteoroid

@apathetichell sir, this is a perfect solution. Had no idea that a file could be read in by a manual path entry without it being discoverable in browse, as alteryx input tool does not support .jsonl. Also, the /n Delimiter requires the File Format (Code Page) to be set to Unicode UTF-8 for a successful read. 

 

PS: the image I posted in my question was just for giving visibility to the file extension 

 

Thank you very much ! you saved me a lot of effort !

apathetichell
19 - Altair

Glad to hear!

Labels
Top Solution Authors