Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I wanted to know , what is generic load and what is the use of it, in what conditions do we use it??
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.
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.
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.
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
Good explanation of concept!!
anant
well explained.