Joining/Merging Tables

[#1]

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

[adamwilson · Accepted solution]

Hi,

you need to Outer Join the tables:

TableName:

Load

   EmployeeID

   Budget

From...

OUTER JOIN (TableName)

Load

   EmployeeID

   Actual

From...

[jagan]

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.