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 |
