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
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
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.
If the Owner ID contains Null, how it needs to be treated.
Please advise.
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
Please find the expected output.
False node input:
👍
