I have a joined database which was created to see if Vendor names matched employee names. As a result I have a column with the agency number (that paid the vendor) and another column with agency number (that the employee works for). I'm trying to obtain a data set that displays agency numbers that match each other on the same row. Is this possible?
jstromain
Offline
Last seen: 4 years 7 months ago
Joined: 03/15/2017 - 09:40
Hi jstromain,
If the information is in the same row and you are comparing two fields together just create a filter or a direct extractions where you have FIELD1 == FIELD2. The fields have to be of the same type so if one is numeric and the other is character you will have to first change one to numeric or character. You will also have to make sure that they are both in the same format, as an example that one field doesn't have additional information or dashes, that would need to be removed in order to do a comparison.
Hope this helps.
Brian
Thanks Brian. You are always a big help