I am currently connected to 2 data sources (ODBC Database and 1 Excel spreadsheet)
While the customers are the same from both data sources the naming convention from both data sources differ.
How can I create a master customer name list so regardless of the data set I select it accuratly shows values from both data sources based on a unified customer name?
Thanks for any insight.
You might need to use mapping table to unify your names:
Mapping LOAD * INLINE [
Bryn Mawr Medical Specialist, Bryn Mawr
Bryn Mawr Hospital, Bryn Mawr
With Applymap statement in load for every source
LOAD ApplyMap('MapNames',Name) as Name