Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello friends,
this is rahim. i am new to qlikview.
can any one please say about generic load with example..
please
if any notes plz forward to my mail
Hi,
Best explain by HIC
And assume this simple example
Generic
LOAD * Inline
[
ID,DESC,Amount
1,A,458741
2,B,12563
3,C,25874
4,D,125632
5,E,14582
6,F,12563
7,G,125693
];
Regards
Anand
Dear Rahim,
Please check these threads,
What is Generic load and when we used Generic load.
Generic load example from QlikView Reference Manual with table consolidation.
Kind regards,
Ishfaque Ahmed
Hi,
check the qlikview reference materials , there is a description on this under "27 Evaluating the Loaded Data"
page no 393.
Thank You.
You can follow this link to know about Generic Prefix.
Hi Rahim,
Go through this thread.
What is Generic load and when we used Generic load.
It will help you.
Regards,
Barathiraja
Hi
Go through this
Generic Databases or Generic Load
A generic database is a table in which the field names are stored as field values in one
column while the field values are stored in second column.
In general used for attributes of different objects
We need spilt one field into multiple fields
Need to use 'Generic' qualifier before LOAD or SELECT Statements
Generic table Must have atleast 3 fields.
Example:
Generic LOAD object,
attribute,
value
FROM
(biff, embedded labels, table is Sheet1$);
thank u so much shaila tyagi
Hello Rahim,
Please go through the below link..
http://www.c-sharpcorner.com/UploadFile/35fef0/generic-database-in-qlikview/
http://community.qlik.com/blogs/qlikviewdesignblog/2014/03/31/generic
thank u barathiraja