Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Load with a condition

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 !

1 Solution

Accepted Solutions
Not applicable
Author

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);

View solution in original post

8 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

Table1:

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

Concatenate

LOAD ID, ....

FROM Table2 ....

WHERE Exists(ID)

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
swuehl
MVP
MVP

LOAD ID,

          ...

FROM Table2

WHERE EXISTS(ID);

Not applicable
Author

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
Employee
Employee

LOAD

     ID

From Table1;

Left Join

LOAD

     ID

From Table2;

Not applicable
Author

thank you

Not applicable
Author

thank you for the answer, it worked

Not applicable
Author

Thank you for the accurate answer, it's working

Not applicable
Author

welcome sir