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]

Spoiler

 

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.

Spoiler

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.

Spoiler

[Flo_P]

Spoiler

Was a bit tricky but fun!

[Towers]

really enjoyed this one!,

Spoiler

 

[rmassambane]

383

[AkimasaKajitani]

My solution for Designer Experience.

Spoiler

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

Spoiler

 

[ARussell34]

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

[BS_THE_ANALYST]

Cool challenge:

Spoiler