Hi all,
Maybe somebody has an idea about the following.
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:
LOAD
[MANDT] AS [Client],
[SPRAS] AS [Language Key],
[BSARK] AS [Customer purchase order type],
[VTEXT] AS [Description]
FROM 'source';
Example of how I want the fields to be renamed based on the suggestion:
LOAD
[MANDT] AS [MANDT_Client],
[SPRAS] AS [SPRAS_Language Key],
[BSARK] AS [BSARK_Customer purchase order type],
[VTEXT] AS [VTEXT_Description]
FROM 'source';
Thank you in advance for your comment/suggestion!
Grtz, Tamarah
