Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

What is Generic load and when we used Generic load.

What is Generic load and when we used Generic load ?

Regards

Ashish Srivastava

7 Replies
Not applicable
Author

Hi Ashish,

Here you are the definition for Generic Load in the Qlikview Manual Reference:

24.1 Generic Databases

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 to the right. 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.

This is a typical generic database. On one hand it would be awkward to store the data in a way giving each attribute a column of its own, since many of the attributes are not relevant for a specific object. On the other hand, it would look messy displaying it in a way that mixed lengths, colors and weights.

QlikView solves this problem in an elegant way. If data is stored in the compact way shown above, you can choose between the two different ways of displaying the data. QlikView automatically creates several logical tables from the generic database.

If this table is loaded the standard way, we can get three different list boxes on the screen. However, if the table is loaded as a generic database, QlikView will split up column two and three into different list boxes.

QlikView will then generate one field for each unique value of the second column.

The syntax for doing this is simple:

Example:

Generic select * from GenericTable;

It does not matter whether a

load or select statement is used to load the generic database.



Check it out for more information.

Best regards.

Not applicable
Author

I am lot of confuse about this.

Kindly explain me with example or qvw file.

Regards

Ashish Srivastava

Not applicable
Author

Ups, sorry.

I've forgot attach the file.

I hope it helps you.

Best regards.

Not applicable
Author

Thanks a ton

This i need.

Regards

Ashish Srivastava

Not applicable
Author

Hi magv,

I understood with your example that what is generic load and what it will do,

but I am not clear about the scenario when to use generic load. Can you please explain the specific scenarios for using generic loads.

sebastiandperei
Specialist
Specialist

ashishkumar, mark as answered if it was helpful

IAMDV
Luminary Alumni
Luminary Alumni

Ashish,

To keep it simple, Generic Load is opposite to CrossTable (Not literally). Using CrossTable you convert Columns to Rows and using Generic Load you can convert Rows to Columns. There is excellent explanation on Rob's blog.

Here is the link :

http://qlikviewnotes.blogspot.co.uk/2010/05/use-cases-for-generic-load.html

Cheers,

DV

www.QlikShare.com