Mapping Name with Customer

[chaitanyajami]

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:

LEFT JOIN (Customer)

  ID AS Name,

  Customer as Customer

RESIDENT CustomerRelation;

[sunny_talwar · Accepted solution]

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]

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.