Forum Discussion
webportal
Impactful Individual
Impactful IndividualCheck if value in column B exists in column A
Using Power Query, I need to check for each row of MyTable if the value in column B exists in column A. If it does, then that value should be returned, then an empy field. This is the code I'm tryi...
webportalImpactful Individual
Impactful IndividualHi, that makes a comparison row by row which always returns false (null).
I need to check if column B exists in the entire column A.
I need to check if column B exists in the entire column A.
artemus
Microsoft Employee
Microsoft EmployeeI think I see what you are getting at.
In this case instead of adding a column, do a self join. Just do a merge on the same table using [A] and [B] as the join columns