topic Re: Dynamic Names of Columns in QlikView

Dynamic Names of Columns

5abi0001 — Wed, 13 Mar 2019 13:16:14 GMT

Hi! 🙂

I have a question .. i have a table with about 15 columns with specific column names.

What i want is, that trough a lookup (an excel or something else) i want to set the names of the columns in QlikView, for example:

In the table with 15 columns there is a name like: LoadDate ..

In the other table (Lookup) i make a matching -> when the columname is LoadDate, i want to set the column name in QlikView Loading Date.

In the script i load both tables .. but now i dont know how i can set the name as in the lookup table, when i make for example a table and set LoadDate as a Dimension.

How is it possible to make this?

I hope you can understand what i want 😄

Re: Dynamic Names of Columns

jaibau1993 — Wed, 13 Mar 2019 15:31:15 GMT

Hi! Please, try something like the following in your script:

//Your data table
LOAD * Inline [
Column1, Col2, Column3, Col4
];

//Your "LookUp" table
MAP_ColNames:
Mapping LOAD * Inline [
PreviousName, NewName
Column1, NewColumn1
Col2, NewColumn2
Col4, NewColumn3
];

//Rename
RENAME Fields using MAP_ColNames;

Hope it helps!

Bests,

Jaime.

Re: Dynamic Names of Columns

5abi0001 — Thu, 14 Mar 2019 11:10:16 GMT

Hi, thank you for your response.

In my Lookup table i have to columns .. rootName and QvName .. than i have values where i already do the matching.

Now when i do the rename it says; Table not found error .. but i have this table.

Re: Dynamic Names of Columns

jaibau1993 — Thu, 14 Mar 2019 11:43:43 GMT

Hi! I think I'll need a sample of your code or a sample file because you may have an error in your script. If you try the code I posted above in a separate file you'll see that it works so I suspect you made a mistake when embbeding it into your script.

Jaime.

Re: Dynamic Names of Columns

5abi0001 — Thu, 14 Mar 2019 15:52:54 GMT

DetailsTable:
LOAD Stand,
LoadDate,

Columnname,

StorageName
FROM
[..\QvdGenerator\qvd\Details.qvd]
(qvd);

MatchingName:
LOAD rootName ,
QvName
FROM
[..\QvdGenerator\qvd\MatchingNameqvd]
(qvd);

RENAME Fields using MatchingName;

Re: Dynamic Names of Columns

jaibau1993 — Thu, 14 Mar 2019 16:14:59 GMT

When you load your lookup table you have to insert the prefix "Mapping" before the LOAD statement:

DetailsTable:
LOAD Stand,
LoadDate,

Columnname,

StorageName
FROM
[..\QvdGenerator\qvd\Details.qvd]
(qvd);

MatchingName:
Mapping LOAD rootName ,
QvName 
FROM
[..\QvdGenerator\qvd\MatchingNameqvd]
(qvd);


RENAME Fields using MatchingName;

Jaime.

Re: Dynamic Names of Columns

5abi0001 — Fri, 15 Mar 2019 11:59:44 GMT

Thank you! It works! 🙂

Re: Dynamic Names of Columns

jaibau1993 — Fri, 15 Mar 2019 12:03:38 GMT

You are welcome! 🙂