Field Identification

Hi,

I have a ID field that might not might not show up in the input file... I need to output without that row that contains but keeping the rest of the rows

Input eg that now has an ID column usually it doesn't but this is a one off case

Name	Amount	ID	Status
A	45		Comp
B	6	A12	Comp
C	2		Comp

Output is a Sum

Sum

Workflow

Help

Accepted answers

Emil_Kos

Hi @clarrock,

I have created a solution for you:

And the output:

Filter input v3.yxmd

messi007

Hi @clarrock,

I have a detour based on the Id and changed the SUM filed:

Attached the workflow.

Please don't forget to mark the my answer as solved if it works for you 🙂

Many thanks 🙂

DynamicFilter.yxmd

All comments

Emil_Kos

Hi @clarrock,

I believe you should use a combination of the filter tool + summarize tool will help you:

Output:

Please mark as a solution if it was helpful!

Filter input.yxmd

clarrock

@Emil_Kos thanks, but if you delete the ID column from the text input file - you will get an error in the filter tool

as mentioned - tomorrows input file might not contain ID field and day after tomorrows file there is an ID field...so it varies. How do I ensure that anything in ID column if there will be ignored?

messi007

Hello @clarrock ,

I have done the solution based on the content of the cell if I found any letter followed by 2 digit I'll consider it as an ID and I'll ignore it.

Attached the workflow.

Hope that helps 🙂

Regards,

DynamicFilter.yxmd

clarrock

@messi007 @Emil_Kos Thank you for your solutions - both are helpful!

But i'm stuck again! 😞

So whenever there is an ID field containing an ID(as it should) - I should summarize Amount1, whereas if theres no ID field in the input I should summarize Amount3 - How do I create a logic in such a way this is done in Alteryx?

eg1 : with ID Column

Name	Amount1	Amount3	ID	Status
A	4	1		Comp
B	5	2	A12	Comp
C	6	3		Comp

Output should ignore the Name B row and sum Amount1

Sum

eg2 : Here the input has no ID column

Name	Amount1	Amount3	Status
A	4	1	Comp
B	5	2	Comp
C	6	3	Comp

Output should just sum Amount3

Sum

(Note in both eg1 and 2 output column header should be "Sum")

Is this possible? Please help!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703