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 |
Solved! Go to Solution.
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!
@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?
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.
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,
@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!
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 🙂