Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
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;
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;
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.