Challenge #383: Data Parsing Delight!

[jpowellsd]

It's been a while since I've had time to do a challenge - this was a great one, thank you! Used a combination of Regex tokenize, text-to-column, and Cross tab to get the job done. 

Spoiler

 

[DataNath]

My solution to #383.

Spoiler

[TerrenceM]

383

[Py12345_54321]

As Ask :

To  showcases the following details:

1. Different condition types of the products
2. Record number associated with each condition
3. Material numbers corresponding to the products
4. Pricing rate for different condition types
5. Dates when these pricing rates were valid (valid from and valid to)

Note: It was a Good Use Case , Helpful

[pankaj_123456789]

It Was a Good Use Case , Helpful

[CeliaC_Silje]

Spoiler

[williamnolan03]

Parsing this data structure is always such a thrill.

[Scheduler]

Here is my workflow

[sakifchowdhury1]

Spoiler

Longer workflow since I did not want to use .jsonparse

[dkungu]

Applied splitting multiple columns into rows and regex