Forum Discussion
Solved
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 p...
For your eference.
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)
For your reference.
I add a "Key_Column" to the each table and change a relationship.
when I use larger set of data, this query is not working.
For your eference.