Creating calculated columns based on headings

[Aria_S]

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

[ImadZidan]

Hello @Aria_S ,

Idea you may find helpful.

[Aria_S]

@ImadZidan ,

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

[ImadZidan]

Hello @Aria_S ,

Another idea.

[DavidP · Accepted solution]

Hi @Aria_S 

How about something like this?

[ImadZidan]

@DavidP ,

I like your solution better.

I thought there must be another better way.