Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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!