topic Re: Generic Load in QlikView

Generic Load

Tue, 06 Jan 2015 08:58:07 GMT

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

skrahim1244@gmail.com

Re: Generic Load

its_anandrjs — Tue, 06 Jan 2015 09:13:03 GMT

Hi,

Best explain by HIC

The Generic Load

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

Re: Generic Load

engishfaque — Tue, 06 Jan 2015 09:19:32 GMT

Dear Rahim,

Please check these threads,

The Generic Load

What is Generic load and when we used Generic load.

Generic load example from QlikView Reference Manual with table consolidation.

Kind regards,

Ishfaque Ahmed

Re: Generic Load

kkkumar82 — Tue, 06 Jan 2015 09:20:14 GMT

Hi,

check the qlikview reference materials , there is a description on this under "27 Evaluating the Loaded Data"

page no 393.

Thank You.

Re: Generic Load

tyagishaila — Tue, 06 Jan 2015 11:21:53 GMT

You can follow this link to know about Generic Prefix.

The Generic Load

Re: Generic Load

Tue, 06 Jan 2015 11:25:04 GMT

Hi Rahim,

Go through this thread.

What is Generic load and when we used Generic load.

It will help you.

Regards,

Barathiraja

Re: Generic Load

rajkumarb — Tue, 06 Jan 2015 11:31:33 GMT

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$);

Re: Generic Load

Tue, 06 Jan 2015 11:40:04 GMT

thank u so much shaila tyagi

Re: Generic Load

Tue, 06 Jan 2015 11:47:18 GMT

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

Re: Generic Load

Tue, 06 Jan 2015 11:48:40 GMT

thank u barathiraja

Re: Generic Load

Tue, 06 Jan 2015 19:05:20 GMT

Hi,

For the Generic load explain and example you can find here with example.

Qlikview Generic Load | Qlikview for life (Qlik4life)

Thanks

Harshul