Reading in .JSONL File in Designer

[Siddhant_Surve]

Hello Community,

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

[apathetichell · Accepted solution]

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]

@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]

Glad to hear!