Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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

Re: Load with a condition

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

8 Replies
MVP
MVP

Re: Load with a condition

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

Re: Load with a condition

LOAD ID,

          ...

FROM Table2

WHERE EXISTS(ID);

Not applicable

Re: Load with a condition

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

Employee
Employee

Re: Load with a condition

LOAD

     ID

From Table1;

Left Join

LOAD

     ID

From Table2;

Not applicable

Re: Load with a condition

thank you

Not applicable

Re: Load with a condition

thank you for the answer, it worked

Not applicable

Re: Load with a condition

Thank you for the accurate answer, it's working

Not applicable

Re: Load with a condition

welcome sir

Community Browser