Compare a field from a list

Hello,

I am looking to match tax fields and application fields in the attached list, the actual file contains 30 columns each in tax and application.

Can anyone help to build the below logic-

If Tax_Country_Citizenship country is present in the country list sheet then 3A should have numeric value

If Tax_Country_Citizenship country is not present in the country list sheet then 3B should be SELECTED.

Compare list.xlsx

Data Investigation

Accepted answers

Luke_C

Hi @Saravanan13

I think you should be able to accomplish most of that based on the example I provided. For example, you should be able to pretty easily tweak the 3B logic based on the sample I gave you by changing the 'then' clause to 'NOT SELECTED' instead of null. Give that a go and share any errors you come across if it's not working.

All comments

Luke_C

Hi @Saravanan13

Here's something that should hopefully get you started:

Find and replace tool set to append fields. This will look for the citizenship country in your list (note case sensitivity - hence the uppercase function). If the country is present it will append a field with the country name. If it isn't present, the appended field will be null
Then you can look at if that new field is null or not to determine the logic you have above.

New Workflow2.yxmd

Saravanan13

Thanks Luke for the reply. There are few more things in this logic. can you assist on this please

3A - will be filled with either a TIN number or it will blank

3B - will be filled with SELECTED or NOT SELECTED

if the country matches with the list then there should be a TIN number filled in 3A then Form is "Approved"

if the country matches with the list and TIN number is blank in 3A then Form is "Rejected"

if the country not match with the list then 3B should be filled as "SELECTED" then Form is "Approved"

if the country not match with the list then 3B should be filled as "NOT SELECTED" then Form is "Rejected"

Luke_C

Hi @Saravanan13

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703