1 Reply Latest reply: Apr 15, 2013 3:59 AM by Thorsten Schröder RSS

    lookup/mapping table for this scenario?

    Thorsten Schröder

      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.