Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Concatenate with implicit "FROM" Clause?

All,

I've inherited a data model with the following code.  1st, table "tmp_SIC" is loaded, it is then followed by a Concatenate statement.  I understand what a Concatenate statement does; however, I'm confused as to how this one works.  This LOAD statement (the first one) does not use a FROM clause.  Is it implied by the following LOAD?


Concatenate (tmp_SIC)
LOAD
*
WHERE
SICConcatIncludeFlag = 1
;

LOAD
//--->Keys
APPLYMAP( '  ...

Thank you in advance,

1 Solution

Accepted Solutions
sunny_talwar

This is called Preceding load. Read about this here: Preceding Load

View solution in original post

2 Replies
sunny_talwar

This is called Preceding load. Read about this here: Preceding Load

oknotsen
Master III
Master III

I think what you have here is something called "LOAD on LOAD" or "Preceding load on preceding load". You effectively do a load right on top of the next load (so you read the who structure from the "from" part up).

I am sure there are documents about this, but a quick search on "load on load" on the help did not give me anything to show you.

May you live in interesting times!