Hi Guys,
I have the below type of data:
Client name | L1 | L2 | Value | Value B |
Client X | AA | X | 10 | 30 |
Client X | AA | Y | 20 | 40 |
Client X | AA | Z | 30 | 50 |
Client X | BB | F | 40 | 60 |
Client X | BB | G | 50 | 70 |
Client X | BB | H | 60 | 80 |
and I would like it in this format: the ultimate output is an email
| X | Y | Z | F | G | H | ||||||
Value | Value B | Value | Value B | Value | Value B | Value | Value B | Value | Value B | Value | Value B | |
Client X | 10 | 30 | 20 | 30 | 30 | 50 | 40 | 60 | 50 | 70 | 60 | 80 |
any help would be highly appreciated!
Solved! Go to Solution.
Just want to highlight that each product X, Y, Z should have the equivalent Value and Value B
X | Y | Z | F | G | H | |||||||
Value | Value B | Value | Value B | Value | Value B | Value | Value B | Value | Value B | Value | Value B | |
Client X | 10 | 30 | 20 | 30 | 30 | 50 | 40 | 60 | 50 | 70 | 60 | 80 |
Hi @giulianosua1,
Here is a workflow that will get close to your desired output, but it's not all the way there. It seems unusual to me to mismatch the L2 headers with their corresponding values, and I found this difficult to accomplish in Alteryx. So the lower datastream is my more traditional output for something like this. Hope it helps!
Thank you ! Really helpful!