Hello all!
I'm new to Alteryx and would appreciate any guidance. I have approximately 80 excel sheets (all in the same structure) and need to transform it to something simpler in order for the designers to visualize. I am able to do this in excel, but I would much rather let Alteryx do the heavy lifting and it makes future updates easier as well.
The request is straightforward, but I can't seem to figure it out.
@Reghero
The solution for this kind of unstructured data always inevitably becomes brutal force...😶
Woah! Didn't expect that, but thanks for your help QIU.
The input dataset structure is not ideal . Unfortunately I'll have to attempt the brute force :(
My alternative is... Don't even want to think about it.😩