Pardon our dust - Alteryx Academy is under construction. Lessons and courses completed on Community from now until January 20th will not be recorded.
Start Free Trial

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

alexnajm
19 - Altair
19 - Altair

Thank goodness for the Community!

Révélation
Challenge 114.PNG
dkungu
Astéroïde

solution

asultanov
Astéroïde
Révélation
Screenshot 2024-02-02 142349.png
Tgigs
Astéroïde

My solution attached.

 

What I actually end up doing is change the output type to .csv but keep the .json file extension and change settings to /0 delimiter which means no delimiter, file does not contain headers in first row, and never quote output fields, so this basically just writes our JSON text string into a text file with a .json file extension. When you read the data in as a JSON type with the input tool there are no issues with reading the data in which means that it works.

 

Spoiler.PNG

DanielG
Quasar

Solved

Bobbyt23
Pulsar

Changed the output and looks good now!

Challenge 114.jpg

DaisukeTsuchiya
14 - Magnetar
14 - Magnetar
Révélation
スクリーンショット 2024-08-14 080321.png
Carolyn
12 - Quasar
12 - Quasar

Solved! I'm very glad there was a video since I was completely lost for what to do. 

 

Révélation
2024-08-20_16-01-01.png

lwolfie
Bolide

Yay for the community group on this one.

Bren_Spill2
12 - Quasar
12 - Quasar
Révélation
image.png