Challenge #383: Data Parsing Delight!

[Tgigs]

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]

スポイラ

 

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

[Yoshiro_Fujimori]

I made two workflows with and without JSON Parse tool.

スポイラ

With JSON Parse tool

Without JSON Parse tool

[TurboToad]

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

スポイラ

[Flo_P]

スポイラ

Was a bit tricky but fun!

[Towers]

really enjoyed this one!,

スポイラ

 

[rmassambane]

383

[AkimasaKajitani]

My solution for Designer Experience.

スポイラ

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

スポイラ

 

[ARussell34]

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

[BS_THE_ANALYST]

Cool challenge:

スポイラ