Check Certain Value in Multiple Columns

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

Chk Certain Value in Mutil Columns.yxmd

Workflow

Expression

Accepted answers

All comments

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

Chk Certain Value in Mutil Columns.yxmd

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

Chk Certain Value in Mutil Columns.yxmd

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.

Chk Certain Value in Mutil Columns_V1.yxmd

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.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15879

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703