Topic: Combining dictionaries?
Combining dictionaries?
Hi,
I'm using "matching analyzer" to check if all the values in column1 of tableA can be found in either column2 of tableB or column3 of tableC. To do that, I created a dictionary for column2 of tableB and another one for column3 of tableC and checked both in "matching analyzer".
Please correct me if I'm wrong, but it seems like the "matching analyzer" is giving the output for each dictionary individually instead of combining two dictionary into one. If that's the case, any idea how I can do that?
Many thanks,
George
I'm using "matching analyzer" to check if all the values in column1 of tableA can be found in either column2 of tableB or column3 of tableC. To do that, I created a dictionary for column2 of tableB and another one for column3 of tableC and checked both in "matching analyzer".
Please correct me if I'm wrong, but it seems like the "matching analyzer" is giving the output for each dictionary individually instead of combining two dictionary into one. If that's the case, any idea how I can do that?
Many thanks,
George
Isn't that excactly what the matching analyzer tells you?
Or at least in the combinations matrix you can look for a line where it says "false, false, false" - those records would be where there are no matches in either of your columns.
Or at least in the combinations matrix you can look for a line where it says "false, false, false" - those records would be where there are no matches in either of your columns.
Got it! I didn't understand the combination matrix before... Many thanks.
Log in by clicking the login link at the top of the screen
Go back to forum.


