I have two data tables each containing ‘Company Name’. I have included a Replace activity on Data Table 1 to replace any reference to “Ltd” or “Limited” with a wildcard.
I’m trying to use a Lookup Data Table activity to match the Company Names in Data Table 1 to Company Names in Data Table 2 and then return the value it has matched with.
Currently though it is updating the original excel with “Company 13” which is the last Company Value from the second data table.
CheckFAMEListVLookUp.xaml (20.8 KB)