Hello,
I have an alteryx problem, where I am trying to create new calculated fields("Cal.") based on the column headers of the data. There are essentially 4 header rows.
Order | NY | TX | FL | OK | NJ | AR | ||
Label1 | A | A | B | B | C | C | ||
Label2 | Table | Desk | Desk | Table | Desk | Table(cal.) | Desk(Cal.) | |
Label3 | SK | SP | CT | CT | CR | AE | ||
123 | 20 | 35 | 100 | 68 | 50 | 100 | 85 | 268 |
456 | 20 | 36 | 150 | 68 | 60 | 200 | 96 | 418 |
567 | 20 | 37 | 90 | 68 | 70 | 300 | 107 | 458 |
890 | 20 | 38 | 170 | 68 | 80 | 400 | 118 | 638 |
456 | 20 | 39 | 100 | 68 | 90 | 500 | 129 | 668 |
Here, Table(Cal.) = 35+50 = 85 and so on
Desk (Cal.) = 100+68+100= 268 and so on
Is there any way I can create these fields where alteyrx will calculate the sum of amounts based on "Label2"?
Help is greatly appreciated!
Thank you,
Aria
¡Resuelto! Ir a solución.
Thanks for sharing the idea. However, I am looking for a dynamic approach. There are over 1000 fields and I really don't know how many fields have "table" or "Desk", to get the "f1,f2s". Is there a way to dynamically have it identify the header and then summarize the values?
Something like- If header= "Table" then add all the corresponding values to Table_Calc
Thank you