In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

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