How to output rows combined from the filter tool having T with 60 records and F with 1700 rows only if there is owner id present in bothTrue and False
Solved! Go to Solution.
Hi @kamals83
The join tool will be able to get the result.
However could you please provide sample input and the expected output to build the workflow you are looking for.
Many thanks
Shanker V
Hi @kamals83
If the Owner ID contains Null, how it needs to be treated.
Please advise.
Many thanks
Shanker V
There will be owner id for all rows. there are no nulls or empty
Input from the False in filter will be
A B C D E
ivan01 10 inventory 19/10/2022 Chennai
Isac12 20 inventory 23/11/2021 Bangalore
Input from the True in the filter will be
Patric -12 inventory 31/08/2020 Chennai
Ivan01 -3 inventory 12/09/2022 Chennai
I want the output as
ivan01 10 inventory 19/10/2022 Chennai
Isac12 20 inventory 23/11/2021 Bangalore
Ivan01 -3 inventory 12/09/2022 Chennai
Hi @kamals83
Thanks for sharing the input and output.
What is the logic behind deriving the output.
Why this is eliminated? Patric -12 inventory 31/08/2020 Chennai
Is column B is considered as the owner id?
What is the business criteria to reflect the below.
ivan01 10 inventory 19/10/2022 Chennai
Isac12 20 inventory 23/11/2021 Bangalore
Ivan01 -3 inventory 12/09/2022 Chennai
Many thanks
Shanker V
The Patric is eliminated because there is negative value only
column A is owner id
Hi @kamals83
How the business logic for the below -ve value
Ivan01 -3 inventory 12/09/2022 Chennai
Even Ivan01 is having negative value. Why it is in the output.
Is it because whether it has positive value in Left node
ivan01 10 inventory 19/10/2022 Chennai
Many thanks
Shanker V
yes ivan is having both negative and positive hence he will be included however patrick had only negative
Hi @kamals83
Please find the expected output.
True node input:
False node input:
Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.
If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!
Many thanks
Shanker V
Hi @kamals83
Done the testing by adding negative value only in True node also.
Its working fine as expected.
True node input:
Output
Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.
If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!
Many thanks
Shanker V