Dubble left keep

[#1]

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

[AbhijitBansode · Accepted solution]

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