Forum Discussion
toovishant
Helper II
Helper IICompare two text string same field between two different tables to identify Match/No Match
Hi Team, I am trying to compare the Room Name between two tables to Match/No Match. I am using below logic to comapre Room Name field between Table 1 and Table 2 The below query dosen't seems to p...
For your eference.
Selva-Salimi
Solution Sage
Solution SageHi toovishant
in this case it seems that lookupvalue can perform better. then you can write as follows:
Validate =
VAR _Table2RoomName = LOOKUPVALUE(Table2[Column4], Table2[Column4], Table1[Column4])
RETURN IF(
Table1[Column4] = _Table2RoomName,
"Match",
"No Match"
)
If this post helps, then I would appreciate a thumbs up and mark it as the solution to help the other members find it more quickly.
toovishantHelper II
Helper IISelva-Salimi - Thanks for the reply
when i use lookupvalue it doesn't recognize Table1[column4] or vise versa. Please can you show by using the sample table and execute this query.