topic Re: Mapping Name with Customer in QlikView

Mapping Name with Customer

chaitanyajami — Tue, 29 Nov 2016 10:57:59 GMT

Hi all,

I have requirement and final out put like below im using a left join syntax as below but couldn't achieve, can someone please help me with the same.

Customer:
ID, Name
1, Ravi
2, Sankar
3, Chandra
4, Raj

CustomerRelation:
PlanID, Custimer
1, 2
3, 4

output is

Table:
Manager, Customer
Ravi, Sankar
Chandra, Raju

Syntax:

sunny_talwar — Tue, 29 Nov 2016 11:02:56 GMT

May be like this:

CustomerMapping:

Mapping

LOAD ID,

Name

FROM Customer;

CustomerRelation:

LOAD ApplyMap('CustomerMapping', PlanID) as Manager,

ApplyMap('CustomerMapping', Customer) as Customer

FROM CustomerRelation;

MK_QSL — Tue, 29 Nov 2016 11:22:55 GMT

If your data is coming from SQL/Oracle database, try to do self join while loading them in QlikView script rather than using QV functionality.