Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
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:
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:
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.
My solution is pretty similar to benjimoser's.
Utilizing regex and splitting columns, then rejoining at the end. Some minor clean up of field formatting as well to match the solution file