Hello,
I have a simple question about the arrange tool, may i use it to arrange my table from like this:
Before:
Dates | A | B | C |
2016-01-01 | 1 | 6 | 11 |
2016-01-04 | 2 | 7 | 12 |
2016-01-05 | 3 | 8 | 13 |
2016-01-06 | 4 | 9 | 14 |
2016-01-07 | 5 | 10 | 15 |
After:
Dates | Name | Value |
2016-01-01 | A | 1 |
2016-01-04 | A | 2 |
2016-01-05 | A | 3 |
2016-01-06 | A | 4 |
2016-01-07 | A | 5 |
2016-01-01 | B | 6 |
2016-01-04 | B | 7 |
2016-01-05 | B | 8 |
2016-01-06 | B | 9 |
2016-01-07 | B | 10 |
2016-01-01 | C | 11 |
2016-01-04 | C | 12 |
2016-01-05 | C | 13 |
2016-01-06 | C | 14 |
2016-01-07 | C | 15 |
I attache an example in Excel, maybe anyone can help me to etablish a workflow Alteryx?
Thanks a lot!
Solved! Go to Solution.
Use a transpose tool (http://downloads.alteryx.com/Alteryx/Help/Transpose.htm).
With Key field set to Date
It's really bralliant!!!!!! Thank you very much