I must be having a bad day. I can't for the life of me remember how to do a data transformation/Unpivot in alteryx.
I have data that comes in the follow format.
Field1 | Field2 | Field3 | Field4 |
1 | (null) | (null) | (null) |
(null) | 2 | (null) | (null) |
(null) | (null) | 3 | (null) |
(null) | (null) | (null) | 4 |
a | (null) | (null) | (null) |
(null) | b | (null) | (null) |
(null) | (null) | c | (null) |
(null) | (null) | (null) | d |
and I need it in this format.
Field1 | Field2 | Field3 | Field4 |
1 | 2 | 3 | 4 |
a | b | c | d |
I can remember how to do it with a multirow formula, but I have 50 some-odd columns and don't want to add 50+ multi formula tools.
And help would be appreciated.
Thanks!
解決済! 解決策の投稿を見る。
Hi @D12monkey,
I think this is what you're trying to achieve?
If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.
Regards,
Jonathan
Hi @D12monkey,
don't worry, we got your back! And here is how to do it:
What happens:
- Transpose everything into Rows
- Filter out all null values
- Add a custom Counter grouped by your Field Name values (Multi-Row-Formula)
- Cross Tab everything back
- Remove the "Counter" Column (Select)
Sample Workflow attached. Let me know if this solved your problem.
Best
Alex