Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
jonvitale
Contributor III

Order of operations in data load script

Hello,

This feels pretty beginner, but I'm not sure what the answer is, so please let me know. If I have script like the following:


Left Join (TableA)

TableB:

Load FRUITS, VEGETABLES from ...

TableC:

Load FRUITS, VEGETABLES from ...

Will table B first join to table A, and then a separate table C will load into memory

OR

Will table B and C concatenate and then the result will be joined with TableA

?

In this case I would prefer that the concatenation occurs before the joining, but I suspect that it wouldn't.

(by the way, I can do a workaround with Residents - no problem - I just want to make sure I understand how the order of operations works in script loads).

1 Solution

Accepted Solutions
Highlighted

Re: Order of operations in data load script

You are right, Table B will first join and then TableC will be created.... that's just how the order of operation work in Qlik View or Qlik Sense and I guess work around that you mentioned might be the only option here...

View solution in original post

4 Replies
Highlighted

Re: Order of operations in data load script

You are right, Table B will first join and then TableC will be created.... that's just how the order of operation work in Qlik View or Qlik Sense and I guess work around that you mentioned might be the only option here...

View solution in original post

Highlighted
jonvitale
Contributor III

Re: Order of operations in data load script

As far as you know there is no way to do something like:

Left Join (TableA)

(

   TableB:

   Load FRUITS, VEGETABLES from ...

   TableC:

   Load FRUITS, VEGETABLES from

)

To force the concatenation before the join?

Highlighted

Re: Order of operations in data load script

I don't think so... you will have to do this just like you think

TempTable:

Load FRUITS, VEGETABLES from ...


Concatenate(TempTable)

Load FRUITS, VEGETABLES from ...


Left Join (TableA)

LOAD *

Resident TempTable;


DROP Table TempTable;

Highlighted
jonvitale
Contributor III

Re: Order of operations in data load script

Yeah, figured. Thought I'd give it a shot thought. Thanks.