Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Joining/Merging Tables

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

1 Solution

Accepted Solutions
dt_adamwilson
Contributor

Re: Joining/Merging Tables

Hi,

you need to Outer Join the tables:

TableName:

Load

   EmployeeID

   Budget

From...

OUTER JOIN (TableName)

Load

   EmployeeID

   Actual

From...

2 Replies
dt_adamwilson
Contributor

Re: Joining/Merging Tables

Hi,

you need to Outer Join the tables:

TableName:

Load

   EmployeeID

   Budget

From...

OUTER JOIN (TableName)

Load

   EmployeeID

   Actual

From...

MVP & Luminary
MVP & Luminary

Re: Joining/Merging Tables

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.