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

[Kinga]

hi,

Please find my solution.

Spoiler

[FinnCharlton]

Spoiler

[ahsanaali]

Spoiler

Rather simple solution.

[kristiadiuisan]

Spoiler

[leonhekkert]

My solution:

Spoiler

Changed into .CSV output with a \0 delimiter

[alacoume]

My solution: 

Spoiler

(see https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Writing-JSON-Files-Wrong-Syntax/td-p/1... )

[mgaronson]

Spoiler

Simple solution if you know. Now I know. Understanding why is the key.

[CeliaC_Silje]

And again, Alteryx Community never disappoints!

Spoiler

So with the help of this post, the reason for extra delimiter is that the data formatted twice - in JSON Build Tool and Output Data Tool.

Instead of using JSON as File Format in Output Data Tool, just simply change to CSV, use \0 (null) as delimiter and uncheck 'First Row Contains Field Names'.

[Flo_P]

Spoiler

Changed the output and that solved it

[bkclaw113]

Spoiler

I have seen this many times.