Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

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

FilipR
11 - Bolide

Solved.

 

Spoiler
FilipR_0-1654253599343.pngFilipR_2-1654254121794.png

 

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
8 - Asteroid
Spoiler
Original_Yodies_0-1658861308100.png

 

acarter881
12 - Quasar

Here's my solution.

Spoiler
my_weekly_challenge_114_solution.png
FrederikE
13 - Pulsar
Spoiler

Same solution as others mentioned.
FrederikE_0-1659804190202.png

 

justynam
8 - Asteroid

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

 

aiahwieder
8 - Asteroid

🤔

 

Hope I never have to use this . . .

grazitti_sapna
17 - Castor

grazitti_sapna_0-1662364543229.png

 

Sapna Gupta
karlhansen
9 - Comet
Spoiler
JSON build plus output to JSON file was doing a double-JSON conversion.  Output to csv with \0 delimiter instead.
martinding
13 - Pulsar

That was faster than it looked!

TungThanhHo
8 - Asteroid

my solution