Forum Discussion
Compare 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 provide the desired output. I need which Room Name is same will be "Match" and if not then it will be "No Match"
Table 1 Table 2
1. Site Code 1. Site Code
2. Floor Code 2. Floor Code
3. Room Code 3. Room Code
4. Room Name 4. Room Name
5. Validate 5. Validate
Thanks,
For your eference.
11 Replies
Hi 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.
Selva-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.
For your reference.
Validate = IF(MAX('Table 1'[Column4]) = MAX('Table 2'[Column4]),"Match","No Match")
Step 0: I use these data below.
Table 1
Table 2
Step 1: I add a relationship.
Step 2: I make a measure.
Validate = IF(MAX('Table 1'[Column4]) = MAX('Table 2'[Column4]),"Match","No Match")
Step 3: I make a matrix and a table.
Matrix
Table
did you have any relatioship between these two tables?! from which table did you use column 1, column2, column3 in visual and why?!
To create a unique column, I need to combine Column(1+2+3) to create a relation between these two Table 1 & Table 2
