Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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

Explaination of the subtle differences of the "Load" & "From" statements

Hi All,

At the moment, I haven't got my head around when to use the following syntax:

"Load" & "from"

vs

"Load" & "SQL Select *" & "From"

vs

"Load" & "Resident"

Could someone kindly explain the subtle differences between the above, and when to use which (ie loading an xl file, vs inline load etc...)

Kind regards,

Rich

1 Solution

Accepted Solutions
Not applicable

Explaination of the subtle differences of the "Load" & "From" statements

Hi,

Depends of the source.
xls file or txt or qvd file you will use Load * from file.qvd;

From a databse (fe SAP erp) you will need to use a connector (ODBC or other). For Sap it gives:

Select * from Table;

Resident is when reading internal table.

first load external table:

MyTable:

Load * from data.txt;

//then read in a second time from internal table:

SecondLoad:

Load * resident MyTable;

hope its clear.

1 Reply
Not applicable

Explaination of the subtle differences of the "Load" & "From" statements

Hi,

Depends of the source.
xls file or txt or qvd file you will use Load * from file.qvd;

From a databse (fe SAP erp) you will need to use a connector (ODBC or other). For Sap it gives:

Select * from Table;

Resident is when reading internal table.

first load external table:

MyTable:

Load * from data.txt;

//then read in a second time from internal table:

SecondLoad:

Load * resident MyTable;

hope its clear.

Community Browser