Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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
Contributor III

Re: Multiple Data Sources and Customer names

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!

Community Browser