Hi,
There is a workflow with 3 Fruit columns ("Number of Apples", "Number of Mangoes" and "Number of Gauva") that are not static. That is, if Raj has any Gauva with him then only that column will be generated in the table, otherwise not. (typical summarize and cross tab in Alteryx).
At one instance:
Names | Number of Apples | Number of Mangoes | Total |
Deevi | 5 | 10 | 15 |
Raj | 6 | 9 | 15 |
Nemat | 7 | 8 | 15 |
Total | 18 | 27 | 45 |
At another instance (number of columns changed as per data)
Names | Number of Gauva | Number of Apples | Number of Mangoes | Total |
Deevi | 1 | 5 | 10 | 16 |
Jim | 1 | 6 | 9 | 16 |
Jacob | 2 | 7 | 8 | 17 |
Total | 4 | 18 | 27 | 49 |
Now, what I need is that a new heading is created, where "Fruit" is the heading after merging all (apples, mangoes, gauva) columns.
Names | Fruit | Total | |
Number of Apples | Number of Mangoes | ||
Deevi | 5 | 10 | 15 |
Raj | 6 | 9 | 15 |
Nemat | 7 | 8 | 15 |
Total | 18 | 27 | 45 |
How do I do this? I went through some similar posts but the main difference here is that these Fruit columns are not static.
Thanks in advance.
Deevi
Solved! Go to Solution.