The link to last week’s challenge is HERE.
This week’s exercise is another example of how Alteryx can take poorly formatted data such as transactional log files and turn it into usable data.
Use Case: A customer has some data that comes with key product information stored at the top of the file. Each data column contains three lines of header information per product (product, market and type). The customer wants this information to be shown in rows for each product.
Objective: Reformat the input data to match the output example.
Michael, I like the simplicity of your solution. Any chance I could see the .yxmd? I'm at email@example.com. My solution (just posted) also works, but uses hard-coding based on observed values...
I think my solution is the same as some others.