Reading in .JSONL File in Designer
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello Community,
Could anyone please describe a way to read in a .JSONL file in designer ?
Solved! Go to Solution.
- Labels:
- Connectors
- Input
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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 !
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Glad to hear!
