Hi Alteryx engineer,
I have case like below , type column might contains dynamic number of values, so the A CAL B CAL is append at rear according to the unique value from type column, then I should put formula in A CAL which is [rate]* [CUR] to get the value of each X CAL, but because the value of type is dynamic, I could not pre-define the column name in Formula Tool and put the formula in it. Any Advice?
type | rate | CUR | A CAL | B CAL | C CAL | D CAL |
A | 1 | 1 | 2 | |||
B | 2 | 2 | 4 | |||
C | 3 | 3 | 9 | |||
D | 4 | 4 | 16 |
more value from type get more column appended
type | rate | CUR | A CAL | B CAL | C CAL | D CAL | E CAL |
A | 1 | 1 | 2 | ||||
B | 2 | 2 | 4 | ||||
C | 3 | 3 | 9 | ||||
D | 4 | 4 | 16 | ||||
E | 5 | 5 | 25 |