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.
toovishantHelper II
Helper II
mickey64
Super User
Super UserStep 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
- toovishant
Sorry, In this sample file column 3 has limited data, it cannot be a unique coumn, because each site may have same room will have same room code accross the floor. So to get a unique column need to add these three Column (1+2+3) (Site+Floor Code+Room Code)
- mickey64
For your reference.
I add a "Key_Column" to the each table and change a relationship.
- toovishant
when I use larger set of data, this query is not working.