We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. 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 #383: Data Parsing Delight!

Tgigs
8 - Asteroid

My solution attached.

 

First parsed all the columns using regex parse, except used tokenize with 3 columns for the condtionType, then used formula to concatenate condtionType fields into one field, then used text to columns tool to add rows based on comma separated condtionType field, then parsed the validFromDate and valdToDate with date time tool, and lastly used select tool to select appropriate fields and data types.

ahsanaali
11 - Bolide
Spoiler
 
Screenshot 2023-08-08 044834.png

Solution without JSON parse tool. The challenge reminds me of my SAP project days :)

Yoshiro_Fujimori
14 - Magnetar

I made two workflows with and without JSON Parse tool.

Spoiler
With JSON Parse tool
Challenge_383_0.png
Without JSON Parse tool
Challenge_383_1.png
TurboToad
9 - Comet

Fun challenge! Couldn't figure out the final sort order and took a minute to get the crosstabs put together correctly.

Spoiler
383.PNG
Flo_P
8 - Asteroid

 

Spoiler
Was a bit tricky but fun!
 

2023-08-08_10-24-47.jpg

 

 

Towers
11 - Bolide

really enjoyed this one!,

Spoiler
Screenshot 2023-08-08 101357.png

rmassambane
10 - Fireball

383

AkimasaKajitani
17 - Castor
17 - Castor

My solution for Designer Experience.

 

Spoiler
スクリーンショット 2023-08-08 225527.png

 This is the solution for Trifacta classic. It''s very easy to parse the JSON part(it is only 5 times selects).

Spoiler
スクリーンショット 2023-08-08 225630.png

ARussell34
8 - Asteroid

This took me longer than I'd like to admit.

 

AR_challenge383.png

BS_THE_ANALYST
13 - Pulsar

Cool challenge:

Spoiler
challengeSolution.png