topic Re: Help in mapping the fields in QlikView

Help in mapping the fields

stanlyrj — Wed, 25 Nov 2020 16:16:04 GMT

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!

Re: Help in mapping the fields

vishsaggi — Wed, 26 Apr 2017 18:33:18 GMT

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);

Re: Help in mapping the fields

stanlyrj — Wed, 26 Apr 2017 19:41:48 GMT

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

Re: Help in mapping the fields

ger_alegria — Wed, 26 Apr 2017 19:42:35 GMT

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

Re: Help in mapping the fields

hector_munoz — Wed, 26 Apr 2017 19:43:11 GMT

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,

Re: Help in mapping the fields

stanlyrj — Mon, 08 May 2017 11:23:37 GMT

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