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

[chandler-gjino]

attaching my solution

[ed_hayter]

Spoiler

Interesting to note that the output tool when writing to JSON was causing the slashes when it followed a JSON build tool. The post on the community for the problem helps solve the puzzle. i opted to just let the output build the JSON but I could have reconfigured the output to output a CSV with no delimiter "\0" and unticked first row as header.

[geoff_zath]

Spoiler

[tristank]

Had no idea and had to look online. It was nice to see that other users also relied on Google to find their answers. I doubt I will ever run into this problem but now I know!

Spoiler

[mithily]

Spoiler

used the suggestion here taught me to think like a CSE: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Writing-JSON-Files-Wrong-Synta...

[gawa]

This is something which annoys us in actual business when data come across a different system

[williamnolan03]

Done! What a fun one.

[olga_strubbe]

Thanks for the challenge. This was my first time using 'JSON Build' tool, pretty neat! :)

[danielprince]

This is a nice challenge to have in mind, a simple mistake that could that a whole day to find

[Hammad_Rashid]