Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

lookup/mapping table for this scenario?

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.

1 Reply
Not applicable

Re: lookup/mapping table for this scenario?

still hoping for ideas.

Community Browser