Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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

Dubble left keep

Dear Community,

I'm got the following situation.

Table_Projects: contains al the project lines in the database.

Table_Machines: contains the Parts

Table_People contains the people people.

Table Projects is really big, To visualize what parts en people are working on a project I would like to Left join them both.

Example:

Table_Machines:

LOAD

Field 1

Field 2

Field 3

Etc.

FROM

DATA\QVD\Table_Parts.QVD

Table_People:

LOAD

Field 1

Field 2

Field 3

Etc.

FROM

DATA\QVD\Table_People.QVD

Table_project:

Left Keep Table_Machines

Left Keep Table_People

LOAD

Field 1

Field 2

Field 3

Etc.

FROM

DATA\QVD\Table_project.QVD

What is the most effective way to do this?

Regards,

Marco

1 Solution

Accepted Solutions
cabhijit
Valued Contributor

Re: Dubble left keep

Load Table_People

Left Join

Load Table_Machines

Left Join

Table_Projects

If you dont want to actually join the tables, go with keep instead of join.

Regards,

Abhijit

1 Reply
cabhijit
Valued Contributor

Re: Dubble left keep

Load Table_People

Left Join

Load Table_Machines

Left Join

Table_Projects

If you dont want to actually join the tables, go with keep instead of join.

Regards,

Abhijit