Hi Alteryx Community,
I'm reaching out for your help in building a sample workflow that transforms a dynamic wide format table into a normalized long format, while preserving tier based pricing per product.
I've been exploring multiple approaches over the past few days using tools like Dynamic Rename, Transpose, and others, but I haven’t been able to get close to the desired result. I’d really appreciate your insights and support in constructing a working example.
What I need to do:
I receive a file each week in the same structure as File 1 Start, and I need to reshape it to match File 2 Result.
Key challenges:
Product names change weekly: they can be any type of material, so the solution must dynamically adapt to new column names.
The number of product columns vary; it can increase or decrease depending on the week.
Tier scales also vary depending on the product.
This is the look of the initial file:
This is the desired result:
I am not savvy with Macros so I would love and I was trying to get the results using only tools no macros.
Thank you!!!
