1 Reply Latest reply: Aug 8, 2012 3:33 PM by Boris Gerchikov RSS

    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

        • Re: Multiple Data Sources and Customer names
          Boris Gerchikov

          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!