Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have two tables which I need to join/merge and I dont know how.
My table is strcutured as follows:
BudgetData:
Load
EmployeeID
Budget
From...
example
ID = Luke, Hans, ObiWan
Budget = 1,2,3
ActualData:
Load
EmployeeID
Actual
From...
example
ID = Luke, Hans, Yoda
Actual = 4,5,6
My problem is that whilst most employees have both actuals and budgets, some employees just have a budget and no actuals, and some have actuals and no budget. I can I get the below table which has it all
Budget+ActualData
ID = Luke, Hans, ObiWan, Yoda
Budget = 1, 2, 3, 0
Actual = 4, 5, 0, 6
Any help most appreciated.
Thanks
Hi,
you need to Outer Join the tables:
TableName:
Load
EmployeeID
Budget
From...
OUTER JOIN (TableName)
Load
EmployeeID
Actual
From...
Hi,
you need to Outer Join the tables:
TableName:
Load
EmployeeID
Budget
From...
OUTER JOIN (TableName)
Load
EmployeeID
Actual
From...
HI,
You can join both the tables by using outer join by using below script
Test:
LOAD * INLINE [
ID, Budget
Luke, 1
Hans, 2
ObiWan, 3
];
OUTER JOIN
LOAD * INLINE [
ID, Actual
Luke, 4
Hans, 5
Yoda, 6
];
Also, there is no need to join these tables, qlikview automatically joins the tables based on the Field names.
Regards,
Jagan.