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 IISorry, 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
Super User
Super UserFor 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.
- mickey64
For your eference.