Missing values

Hi,

I have 2 kinds of files and i want to find a formula that say - group by X and sum. if you don't find X then group by Y and sum.

the difference between the files is that one file has X column and the other has Y.

is that possible?

Thanks in advance!

Tomer

Common Use Cases

Accepted answers

FrederikE

@Tomer123

2 Solutions in the attached WF, both should work.

The 1st is static, if the column order or smth changes it won't work. 2nd will work ether way.

New Workflow6.yxzp

All comments

FrederikE

I am not sure if I understand correctly, maybe we need an example.

You could just import the file without the header and then make sure that both files will have X or Y at the same position. This position (which will have a default name FieldX) can then be grouped via a summarize Tool.

Tomer123

I've uploaded an example file within there are to tabs with the same data beside the column name (amount/total charge)

so i want to tell Alteryx, "if you can't find column named "Amount", go to column named "total charge", and SUM it

New Microsoft Excel Worksheet (3).xlsx

FrederikE

@Tomer123

2 Solutions in the attached WF, both should work.

The 1st is static, if the column order or smth changes it won't work. 2nd will work ether way.

New Workflow6.yxzp

Tomer123

Works! Thanks!!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703