topic Joining/Merging Tables in QlikView

Joining/Merging Tables

Fri, 04 Jan 2013 16:00:44 GMT

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

Re: Joining/Merging Tables

adamwilson — Fri, 04 Jan 2013 16:13:31 GMT

Hi,

you need to Outer Join the tables:

TableName:

Load

EmployeeID

Budget

From...

OUTER JOIN (TableName)

Load

EmployeeID

Actual

From...

Re: Joining/Merging Tables

jagan — Fri, 04 Jan 2013 17:19:42 GMT

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.