Challenge #114: Think Like a CSE...Remove the extra delimiter from the JSON output

[FilipR]

Solved.

Spoiler

The key lies in converting the output format into something else than JSON - CSV for example (this looks like an oversight on the part of Alteryx, though, and something that should be fixed!), then removing the headers and adding "\0" as delimiters. It leaves out the beginning and the end of the original JSON string output, so I added a formula that brings it back. Not sure if it's needed, though. 

[Original_Yodies]

Spoiler

[acarter881]

Here's my solution.

Spoiler

[FrederikE]

Spoiler

Same solution as others mentioned.

[justynam]

It was useful, will save some time I would spent in the future trying to understand the issue in the real world

[aiahwieder]

🤔

Hope I never have to use this . . .

[grazitti_sapna]

[karlhansen]

Spoiler

JSON build plus output to JSON file was doing a double-JSON conversion.  Output to csv with \0 delimiter instead.

[martinding]

That was faster than it looked!

[TungThanhHo]

my solution