Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
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

Re: Concatenate with implicit "FROM" Clause?

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

View solution in original post

2 Replies

Re: Concatenate with implicit "FROM" Clause?

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

View solution in original post

oknotsen
Honored Contributor III

Re: Concatenate with implicit "FROM" Clause?

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!