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
Solved! Go to Solution.
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