Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Can any body plz share the doc's about Inline load.
thanks in advnce
Have you searched in help? Any doubt there?
load [ distinct ] *fieldlist
[( from file [ format-spec ] |
from_field fieldassource [format-spec]
inline data
[ format-spec ] |
resident
table-label |
autogenerate size )]
[ where criterion | while criterion ]
[ group_by groupbyfieldlist ]
[order_by orderbyfieldlist ]
Dear Sree Vas,
Use the below syntex for inline load in qlikview:
KPI_Sort_Order_Executive_Summary:
LOAD * INLINE
[
OP_KPI_ID, Sort order
CSL, 1
TFR,2
RETURN,3
DC,4
ADSO,5
DSOEB,6
DTS,7
WFA,8
EI,9
COG,10
SFS,11
PPOC,12
];
for inline load you have to make a table in qlikview itself, inline load means data is loaded from table which resided within same QVW.
There are different ways and methods to load data into Qlikview. Explained below with examples and uses of methods of loading data into qlikview.
Types:
Example:
LOAD A, B
FROM
InsertàLoad Dataà Inline Data.
Example:
LOAD * INLINE [
A
B
C
];
Example:
Employees:
Select Empname,
HireDate,
Salary,
Incentives
From Employee;
Load Empname,
Month(HireDate),
Salary + Incentives as ‘GrossSalary’
Resident Employees;
Example:
SQL SELECT PrimaryKey, X, Y FROM DB_TABLE
WHERE ModificationTime >= #$(LastExecTime)#
AND ModificationTime < #$(BeginningThisExecTime)#;
Concatenate LOAD PrimaryKey, X, Y FROM File.QVD;
STORE QV_Table INTO File.QVD;
Loading data from one qlikview file is called Binary Loading. The data model of one QVW file is copied from RAM to disk in 0s and 1s for another qvw file.
This Binary Load will be more usefull when you want to enhance the already built qvw with the same metrices defined.
Example:
Binary c:\order.qvw;
Add Load is used to append or concatenate the data from one table to other table. During a partial reload the QlikView table, for which a table name is generated by the add load/add select statement (provided such a table exists), will be appended with the result of the add load/add select statement.
Since it wont check for duplicates, it is required us suitable where condition in the script.
Example:
LOAD ENO, ENAME from Employees.csv;
ADD LOAD ENO, ENAME from Employees1.csv Where Not Exists(ENO);
Buffer load helps to create the QVD files automatically. The created QVD will be maintained as defined in User Preferencesà Locations.
Example: Buffer select * from Employees.csv;
Ref : Shiva Sankar CITAGUS