Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Multiple Data Sources and Customer names

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:

  • Database Source: Bryn Mawr Medical Specialist
  • Excel Spreadsheet: Bryn Mawr Hospital

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

1 Reply
bgerchikov
Partner - Creator III
Partner - Creator III

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!