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!
Solved! Go to Solution.
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.
Thanks Kat! This worked perfectly and i'm getting the results that I needed.
Thanks Charlie!