Generic Load

[#1]

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

[Anonymous · Accepted solution]

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.

[#3]

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.

B.

[#4]

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

[Anonymous]

Good explanation of concept!!

anant

[Anonymous]

well explained.