Hello,
Not sure if this is the way to go…
I’m trying to compare tbl 1 to tbl 2. From the compare, I would like to produce a list of records from tbl 1 that aren’t contained in tbl 2. Similar to a fuzzy search??
Ex.
Record 1 in tbl 1 “A0” exists (contained) in all 14 records from tbl 2, so this would be excluded from the results list.
Record 2 in tbl 2 “A0%%%0” exists (contained) in the first 2 records from tbl 2, so this would be excluded from the results list. Etc…
Record 8 in tbl 2 “A0%%%1D”, doesn’t exist in tbl 2, so this would be part of the list. Etc..
Table 1 Table 2
A0 A0%%%0A
A0%%%0 A0%%%0B
A0%%%0A A0%%%1A
A0%%%0B A0%%%1B
A0%%%1 A0%%%2A
A0%%%1A A0%%%2B
A0%%%1B A0%%%3A
A0%%%1D A0%%%3B1A
A0%%%2 A0%%%3B1B
A0%%%2A A0%%%3B1C1
A0%%%2B A0%%%3B1C2
A0%%%2C A0%%%3B1D
A0%%%3 A0%%%3B1E
A0%%%3A A0%%%3B1F
A0%%%3B
So, results from the example above would be:
Tbl
A0%%%1D
A0%%%2C
Thanks for the help.
Drew
Not sure if this is the way to go…
I’m trying to compare tbl 1 to tbl 2. From the compare, I would like to produce a list of records from tbl 1 that aren’t contained in tbl 2. Similar to a fuzzy search??
Ex.
Record 1 in tbl 1 “A0” exists (contained) in all 14 records from tbl 2, so this would be excluded from the results list.
Record 2 in tbl 2 “A0%%%0” exists (contained) in the first 2 records from tbl 2, so this would be excluded from the results list. Etc…
Record 8 in tbl 2 “A0%%%1D”, doesn’t exist in tbl 2, so this would be part of the list. Etc..
Table 1 Table 2
A0 A0%%%0A
A0%%%0 A0%%%0B
A0%%%0A A0%%%1A
A0%%%0B A0%%%1B
A0%%%1 A0%%%2A
A0%%%1A A0%%%2B
A0%%%1B A0%%%3A
A0%%%1D A0%%%3B1A
A0%%%2 A0%%%3B1B
A0%%%2A A0%%%3B1C1
A0%%%2B A0%%%3B1C2
A0%%%2C A0%%%3B1D
A0%%%3 A0%%%3B1E
A0%%%3A A0%%%3B1F
A0%%%3B
So, results from the example above would be:
Tbl
A0%%%1D
A0%%%2C
Thanks for the help.
Drew