I want to do a fuzzy lookup across two columns. How can I achieve this.
I have a table called companies and there is column called name in the table.
I have another table called typecode and there is a column called typecode in the table.
My source table contains column name and typecode which I need to do a lookup on the table companies and typecode respectively.
I know how to achieve with one column i.e if I take my source table and do a lookup with just name column in companies it is working fine.
How can I achieve this with both the companies table and typecode table and get the name and typecode column in the destination.
Thanks in advance.
View Complete Post