Load with a condition

[#1]

Hello to all,

I have two tables I want to load in my script. I load Table1 first, with an ID field. I want to load for the Table2 only lines with an ID that existe in the Table1.

How to do so?

Thank you !

[jonathandienst]

Table1:

LOAD ID, .... FROM Table1....;

Concatenate

LOAD ID, ....

FROM Table2 ....

WHERE Exists(ID)

[swuehl]

LOAD ID,

          ...

FROM Table2

WHERE EXISTS(ID);

[#4 · Accepted solution]

YASSER TRY THIS

Fact:

LOAD

id,

xyz;

...from fact;

--many tables in between these tables has id fields

SalesPerson:

LOAD id,

SalesPerson, from ...

Where Exists(id);

[ToniKautto]

LOAD

     ID

From Table1;

Left Join

LOAD

     ID

From Table2;

[#6]

thank you

[#7]

thank you for the answer, it worked

[#8]

Thank you for the accurate answer, it's working

[#9]

welcome sir