Finding single value in field column

I'm trying to compare a single base value to all the possible option in a filed (column).

For example, I'm trying to identify that 3623 under Field ExpLine is a perfect match with one of the values in the Compare field. If it does not match then I want a result of "No"

Thank you!

Macros

Best Practices

Fuzzy Match

Accepted answers

kat

Hi @henrymk5

The append solution will definitely work, but I'd recommend looking into the join option, as having the append could get really slow, depending on your dataset size.

join.yxmd

All comments

CharlieS

To evaluate each row, the easiest way would be to append that value to each row and using an IF statement to test.

An example solution is attached.

20181019-MatchRow.yxmd

kat

Hi @henrymk5

The append solution will definitely work, but I'd recommend looking into the join option, as having the append could get really slow, depending on your dataset size.

join.yxmd

henrymk5

Thanks Kat! This worked perfectly and i'm getting the results that I needed.

henrymk5

Thanks Charlie!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703