Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!
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
17 - Castor
17 - Castor

Thank goodness for the Community!

Spoiler
Challenge 114.PNG
dkungu
8 - Asteroid

solution

asultanov
8 - Asteroid
Spoiler
Screenshot 2024-02-02 142349.png
Tgigs
8 - Asteroid

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
12 - Quasar

Solved

Bobbyt23
12 - Quasar

Changed the output and looks good now!

Challenge 114.jpg

DaisukeTsuchiya
14 - Magnetar
14 - Magnetar
Spoiler
スクリーンショット 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. 

 

Spoiler
2024-08-20_16-01-01.png

lwolfie
11 - Bolide

Yay for the community group on this one.

Bren_Spill
12 - Quasar
12 - Quasar
Spoiler
image.png