Help in mapping the fields

[stanlyrj]

Hi All,

I'm new to QlikView, so I'm still getting my feet wet here I'm trying to modify the Customer field in the "Customer" table as Customer-Branch name

But while using Apply map method it does not map completely

/***********************Mapping Load******************/

MappingLoadCustomerIDtoBranch:

Mapping Load _KEY_Customer,_KEY_Branch

FROM [../1_QVD/Tra/Facts/Customer_Invoices.qvd](qvd);

/*********************** Customer *********************/

Customer_Temp:

LOAD

   _KEY_Customer,

  [Customer ID], 

  Cli_Nombre AS Customer,

  ApplyMap('MappingLoadCustomerIDtoBranch',[Customer ID], null()) as [Branch] ,

[Customer Billing State],

  [Customer Category],

  [Customer Group],

  [Customer Family],

[Customer Status],

[Customer EntryDate]

FROM [..\1_QVD\Ext\Dims\Customer.qvd](qvd);

I've tried looking at other postings but I'm not being able to translate them to my reality. Any assistance will be very welcome.

Thanks!

[vishsaggi]

Did you try this?

LOAD

  _KEY_Customer,

  [Customer ID],

  Cli_Nombre AS Customer,

  ApplyMap('MappingLoadCustomerIDtoBranch', _KEY_Customer , null()) as [Branch] ,

[Customer Billing State],

  [Customer Category],

  [Customer Group],

  [Customer Family],

[Customer Status],

[Customer EntryDate]

FROM [..\1_QVD\Ext\Dims\Customer.qvd](qvd);

[stanlyrj]

Hi Vishwarath,

I have tried this

ApplyMap('MappingLoadCustomerIDtoBranch', _KEY_Customer , null()) as [Branch] ,

Since _KEY_Customer and _KEY_Branch are in many to many relationships all the Customer ID are not mapped with _KEY_Branch. Could ou please suggest me any alternatives to achieve this result.

Thanks

[ger_alegria]

You have to create a Mapping table and after that you can use the Applymap funtion.

[hector_munoz]

Hi Stanly,

Try something like this:

/***********************Mapping Load******************/

Mapping1:

Mapping Load _KEY_Branch,

             Branch

FROM         [XXX.qvd](qvd);

MappingLoadCustomerIDtoBranch:

Mapping Load _KEY_Customer,

             ApplyMap('Mapping1', _KEY_Branch, Null())     AS CustomerBranch

FROM         [../1_QVD/Tra/Facts/Customer_Invoices.qvd](qvd);

/*********************** Customer *********************/

Customer_Temp:

LOAD _KEY_Customer,

     [Customer ID],

     Cli_Nombre AS Customer,

     ApplyMap('MappingLoadCustomerIDtoBranch',_KEY_Customer, null()) as [Branch] ,

     [Customer Billing State],

     [Customer Category],

     [Customer Group],

     [Customer Family],

     [Customer Status],

     [Customer EntryDate]

FROM [..\1_QVD\Ext\Dims\Customer.qvd](qvd);

Regards,

H

[stanlyrj · Accepted solution]

Thanks for your reply. Since _KEY_Customer and _KEY_Branch are in many to many relationships all the Customer ID are not mapped with _KEY_Branch.

I was able to solve the issue by creating a table by combining two tables Branch and Customer, along with a Customer-Branch composite key.
Cartesian product in QV
I used the above discussion as a reference.

Thank you

Stanly