Alteryx Designer Cloud Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Cloud.

How do I restructure JSON files ?

In the docs it states that the JSON input data has to have one JSON object per line. ( )

Suffice to say that a lot of JSON data is pretty formatted for better readability. But this in turn seems to mess up Dataprep parsing.

Is there a way to reformat JSON into the ideal format with "one valid JSON object per line" ?

Alteryx Alumni (Retired)

You could use JQ ( ) to reformat your JSON

You can give it a try via JQ Play ( ) and use the "compact output" option, which will result in exactly one object per line. JQ Play will also provide you with the exactly needed JQ command-line to use on your greater data set


That's awesome, thanks for the tip