Creating muliple calculated field

Kuha

Hi,

I have to calculate for 12months x 5 years x 2, ie120 calculated fields.Is there any easy way to create multiple calculated field? Thanks.

	E1-Jan-2023	E1-Feb-2023	E1-Mar-2023		E1-Jan-2024	E2-Feb-2024	E3-Mar-2024		Var1	Var2	Var3
Asset1	100.00	112.00	125.44		175.00	196.00	219.52		75.00	84.00	94.08
Asset2	120.00	134.40	150.53		210.00	235.20	263.42		90.00	100.80	112.90
Asset3	144.00	161.28	180.63		252.00	282.24	316.11		108.00	120.96	135.48
Asset4	172.80	193.54	216.76		302.40	338.69	379.33		129.60	145.15	162.57
Asset5	207.36	232.24	260.11		362.88	406.43	455.20		155.52	174.18	195.08

FrederikE

Hey @Kuha,

I would always recomend to instead generate multiple Rows and use a long data format instead (since Alteryx performance much much better with it). 

This is possible with the Generate Rows Tool for example. 

If you want to, you could then transpose it after your workflow to columns again,.