Check Certain Value in Multiple Columns

[k3pineapple]

Hi Expects, happy 2023

The purpose is to check given values whether are in such columns. if yes, get the whole row into the output.

Seeking your help to build a check function that I may use it by inputting the different variables instead of changing the value in 'Filter' tools

I understand that I may use filter tools to get the result.  The method I'm using right now:

Applying ‘Filter’ Tool

[column1] in ('user A','user B') or

[column2] in ('user A','user B')

...

Looking for another sufficient method to replace the steps above. Thank you

[ShankerV]

Hi @k3pineapple 

One more way is to use Join tool, 

It will help to get the expected output.

Many thanks

Shanker V

[ShankerV]

Hi @k3pineapple 

Please find the expected output.

Please refer the J node. 

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]

Hi @k3pineapple 

The filter criteria is replaced by Left and Right join highlighted in yellow.

Also you can deselect the Right Sname and Right SID in the output which I have kept it for reference to check whether the filter worked correctly.

Deselecting will help to remove the same from output.

Before Deselecting:

Output after deselecting:

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

[k3pineapple]

Hi Shanker, thx for the help. But unfortunately, no, its not seems right.

I would like to have the output to see all columns which contain both users.

Join function not working here. as you may check the result, Two rows missed here.

Need to use these input value to check all three columns automatically not manually input the column title. Thank you

[ShankerV]

Hi @k3pineapple 

You do with the help of Append Fields also.

But it will create a huge data set  as below which is not advisable for huge dataset.

Then I need to filter and then use select tool.

Many thanks

Shanker V

[ShankerV]

Hi @k3pineapple 

Can you please share the same output expected.

Many thanks

Shanker V

[k3pineapple]

Sry, my bad, the expected output already in the sample workflow but named incorrectly, which is on the right hand side.

Expected output with previous method workflow also included in the attachment.

[ShankerV]

Hi @k3pineapple 

Please advise the below

Input has 10 records

Output has 8 records

What it the logic used to filter only 8 records.

Based on the filter logic used, I can proceed with the solution.

As the filter logic is missed to explain in the request. Kindly do the needful.

[k3pineapple]

I would like to check the list of users who are mapped to given sales in both primary sales(Sales Name 1) or backup sales (Sales name 2 & 3) in product level

In the case,  give users are Amy and Bob. They have been mapped to several users(Cust ID) as either primary sales or backup sales in product level.

Rows 9 & 10 has no sales mapping for Amy and Bob. Therefore, there are exclude in the output.

Hope this better explain my request. Thank you very much.