Challenge #383: Data Parsing Delight!

[AYXAcademy]

A solution to last week’s challenge can be found here.

This challenge comes to us from @The_Rad_Valentina    Thank you for your contribution, Valentina!

Ever wondered how the prices of various products are determined in your thrift store? Well, it all depends on their condition and other factors. Thankfully, your local store has a database that handles this, but there is a slight hiccup—the database contains a single column (Payload) with all this data. To address this, you have been tasked with creating a report that 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)

The challenge lies in parsing the information from the Payload column to create a comprehensive report listing each price on a separate line.

Hint: Some Price records have more than one condition type. For example:

This is an example of the report:

[benjimoser]

My Solution. I did a longer workflow, since I wanted to additionally generate a report that contains all information before applying any filter or dropping any columns.

Spoiler

[PhilipMannering]

Solution attached.

Spoiler

[Luke_C]

Spoiler

[Kenda]

Spoiler

[nSpire]

Spoiler

[AkimasaKajitani]

My solution.

Spoiler

 

[Djforesman]

My solution is pretty similar to benjimoser's. 

Spoiler

 Utilizing regex and splitting columns, then rejoining at the end. Some minor clean up of field formatting as well to match the solution file

[RolandSchubert]

Spoiler

[ed_hayter]

Spoiler

Pretty sure I brute forced this and the solution is not dynamic but a fun challenge