Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
I want to know about generic load in qlikview.Can anyone explain me with example.
http://d1cf4w4kkla6tb.cloudfront.net/documentation/9.00/latest/_Qvs/Qvs%20Reference%20Manual.pdf
Generic
The unpacking and loading of a generic database can be done with a generic
prefix. For a description of a generic database, see page 475.
The syntax is:
generic ( loadstatement | selectstatement )
Examples:
Generic Load * from abc.csv;
Generic Select * from table1;
The load statement syntax is described on page 309. The select statement
syntax is described on page 329.
Tables loaded through a generic statement cannot be concatenated.
Hi,
Please look into this generic load example. It may help you to understand more.
Thanks & Regards,
Saravanan.
Hi,
What is the advantage of doing generic reload?
Please explain.
Regards
Andrew Hudson
Hello,
The advantage of using Generic Load is to use the attributes of different object. In simple words, if you need to convert rows into columns then you use Generic Load.
Thanks and Regards,
Ankita
Hi,
below links help to understand Generic load concept:
http://qlikviewcookbook.com/2010/05/use-cases-for-generic-load/
http://community.qlik.com/docs/DOC-3020
Regards
Neetha