lookup/mapping table for this scenario?

Fri, 12 Apr 2013 10:44:13 GMT

Hello everyone,

I will have to deal with a "variable" database table structure because my import files are likely to change (more or less columns) once in a while which then should be mapped to the one db-table.

Basically each import file will have a new VersionID if the data/column structure has been changed.

Thus, my db-model now only has Col1 to ColN column names.

Since QlikView works on column names I was thinking that I could have a lookup Excel table to assign the generic column name to a new column name depending on the VersionID.

Example:

LookupTable:

VersionID | ProductID | Col1 | Col2 | Col3 |...

1 | A |newCol1Header|newCol2Header|

2 | A |newerCol1Header|newerCol2Header|

If this is a good approach I'm hoping that you can help me with an example.

thank you.

Re: lookup/mapping table for this scenario?

Mon, 15 Apr 2013 07:59:47 GMT

still hoping for ideas.

topic lookup/mapping table for this scenario? in QlikView

lookup/mapping table for this scenario?

Re: lookup/mapping table for this scenario?