How to output rows combined- pleas ehlep

[kamals83]

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

[ShankerV]

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

[ShankerV]

Hi @kamals83 

If the Owner ID contains Null, how it needs to be treated.

Please advise.

Many thanks

Shanker V

[kamals83]

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

[ShankerV]

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

[kamals83]

The Patric is eliminated because there is negative value only

column A is owner id

[ShankerV]

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

[kamals83]

yes ivan is having both negative and positive hence he will be included however patrick had only negative

[ShankerV]

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

[ShankerV · Accepted solution]

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