Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Example:
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.
Rob
Hi Robert,
You might need to use mapping table to unify your names:
MapNames:
Mapping LOAD * INLINE [
From, To
Bryn Mawr Medical Specialist, Bryn Mawr
Bryn Mawr Hospital, Bryn Mawr
];
With Applymap statement in load for every source
WhateverTable:
LOAD ApplyMap('MapNames',Name) as Name
Resident Source;
Good Luck!