Rename fields of a table (with applymap function ?)

[#1]

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!

[Miguel_Angel_Baeyens]

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