Field Identification

[clarrock]

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

47

[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!

[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?

[Emil_Kos]

Hi @clarrock,

I didn't get that part. Actually the best easiest solution I know would be adding the ID column to make sure that you always have it. If you will not need it you can always remove it at a later stage.

[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,

[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

10

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

6

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

Is this possible? Please help!

[Emil_Kos · Accepted solution]

Hi @clarrock,

I have created a solution for you:

And the output:

[messi007 · Accepted solution]

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 🙂