I'm working with a SAP database and extract the data with the Theobald connector. This connector has an option to generate a Qlik script with a rename option included. Works like a charm but the renaming is without the original fieldname (a code). What I want is to rename the fields using the original fieldname. Of course this can be done manually. But I was wondering if there is a way to do this automated within my script.
Example with the suggested renames from the connector:
[MANDT] AS [Client], [SPRAS] AS [Language Key], [BSARK] AS [Customer purchase order type], [VTEXT] AS [Description]
Example of how I want the fields to be renamed based on the suggestion:
[MANDT] AS [MANDT_Client], [SPRAS] AS [SPRAS_Language Key], [BSARK] AS [BSARK_Customer purchase order type], [VTEXT] AS [VTEXT_Description]