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:
- Different condition types of the products
- Record number associated with each condition
- Material numbers corresponding to the products
- Pricing rate for different condition types
- 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:
