topic Re: Generic Load in QlikView

Generic Load

Thu, 22 Nov 2012 09:34:15 GMT

I wanted to know , what is generic load and what is the use of it, in what conditions do we use it??

Re: Generic Load

Anonymous — Thu, 22 Nov 2012 09:53:06 GMT

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 a second. Generic databases are usually used for attributes of different objects.

Consider the example below. It is a generic database containing two objects, a ball and a box. Obviously

some of the attributes, like color and weight, are common to both the objects, while others, like diameter,

height length and width are not.

Imagine the following table:

object attribute value

ball color red

ball diameter 10 cm

ball weight 100 g

box color black

box height 16 cm

box length 20 cm

box weight 500 g

box width 10 cm

Loaded in QlikView we get three tables:

Object, Attribute & Value

With Generic Load we get:

Object, Color, Weight, Diameter, Width, Height & Length

See chapter 27.1 in the QV Reference Manual.

Re: Generic Load

Thu, 22 Nov 2012 09:56:58 GMT

Hi,

generic load splits a table with many columns to many smaller tables that have the name of the values of the last but one column of the original table. If your table is ORIGINAL:

A B C Name Value

1 2 a Prod 12

2 2 b Sal 23

3 2 c Marg 2

you'll get 3 differnet tables when you Generic Load * from ORIGINAL

ORIGINAL.Prod

A B C Prod

1 2 a 12

ORIGINAL.Sal

A B C Sal

2 2 b 23

and ORIGINAL.Marg

A B C Marg

3 2 c 2

You can then (if you want so) join the three small tables and you'll have as a result the last 2 columns of the original table transformed from vertical to horizontally oriented. In this sense generic load is opposite of CrossTable. If you write Crosstable(Name, Value, 3) load * from the joined three small tables you'll get again the original table.

Hope this helps.

Re: Generic Load

Thu, 06 Jun 2013 11:04:02 GMT

borislav,

My generic load has generated 52 different table. Is it possible to merge them all to single table with 52 columns? If so, how?

Thanks,

Dror

Re: Generic Load

Anonymous — Wed, 26 Feb 2014 05:39:46 GMT

Good explanation of concept!!

anant

Re: Generic Load

Anonymous — Wed, 25 Jun 2014 06:07:30 GMT

well explained.