Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
still hoping for ideas.