Sum Function in ALteryx

Hello Team,

I have ~100 columns in my file and I need to insert many new columns adding existing columns.

For Eg. I have Q1 2020 data for one state + Q1 2020 data for second state in one column

similarly few new columns to be added for all the periods. Do I need to add so many formula functions in my workflow (It would be almost 25 formula functions)

Datasets

Accepted answers

AbhilashR

Please try opening the attached version. You will have to modify the input tool and map it to the excel file on your machine.

sample.yxmd

All comments

ydmuley

Hello @BhatiaSakshi - You can try "Multi-Field' Formula to achieve this objective.

If the new columns that you want to add have a common pattern of arithmetic, you can leverage this tool to create new fields in a defined way.

I hope this helps. If not, please provide more specific details (with example if possible) so that I can moc-up something quickly and send it over.

Thanks,

Yug

BhatiaSakshi

Hi, Thanks for the prompt response!!

I am attaching the file with dummy data for easy understanding.

I need to add 36 columns if you see where I can add sales 1+sales 2, receipts 1 +receipts 2, income 1 +income 2 for all the periods (which is 12 qtr). so 12 column for each sales, receipts and income 12*3=36 columns to add.

Let me know in case of any disconnect

Book1.xlsx

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703