Generic load with extra columns

Fri, 24 May 2013 11:44:09 GMT

I have EAV/Property bag database structure which I want to load using GENERIC LOAD. The problem is, each property row also has ValidFrom and ValidTo colums, and including those in the load script produces huge amount of tables.

Database structure:

EntityID int

PropertyName string

PropertyValue string

ValidFrom date

ValidTo date

I tried to load it like this, which gives me tons of tables with numbering like 40123 (date I quess?):

GENERIC LOAD

AutoNumber(EntityID, 'Entity') AS Entity,

PropertyName,

PropertyValue,

ValidFrom,

ValidTo

This load will give the correct table structure, but I still need those two extra columns for each row:

GENERIC LOAD

AutoNumber(EntityID, 'Entity') AS Entity,

PropertyName,

PropertyValue

topic Generic load with extra columns in QlikView

Generic load with extra columns