dynamic column and value generation

[187]

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

[binuacs]

@187 One way of doing this

[Zok]

Another way