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. OrderNYTXFLOKNJAR Label1AABBCC Label2 TableDeskDeskTableDeskTable(cal.)Desk(Cal.)Label3SKSPCTCTCRAE 1232035100685010085268456203615068602009641856720379068703001074588902038170688040011863845620391006890500129668 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

Creating calculated columns based on headings

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

Input

Regex

Output

Tips and Tricks

Parse

Best Practices

Transformation

Accepted answers

DavidP

Hi @Arunima_S

How about something like this?

sum desk and table.yxmd

All comments

ImadZidan

Hello @Arunima_S ,

Idea you may find helpful.

AddSpecificColumns.yxmd

Arunima_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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703