Rename fields of a table (with applymap function ?)

Mon, 18 Jun 2012 11:40:05 GMT

Hello,

I get data from a database with a lot of technical fields. I would like to rename these fields:

not with a normal as [new field]
but in describing the new fields in a table, for example a spreadsheet table so that it's easier to manage. I would like to write an instruction in the load that gets the new field in the "Desc" Table

I would like the result like in the "Result" table. How can I do this ? I tried with applymap but without success.

Thank you for your help!

Re: Rename fields of a table (with applymap function ?)

Miguel_Angel_Baeyens — Mon, 18 Jun 2012 11:46:39 GMT

Hi,

Yes, there is an option using MAPPING load and RENAME USING as in the attached example. Of course, instead of an inline table you can get the corresponding names from a database table or an excel file.

Hope that helps.

Miguel

topic Rename fields of a table (with applymap function ?) in QlikView

Rename fields of a table (with applymap function ?)

Re: Rename fields of a table (with applymap function ?)