Rename fields useing original fieldname

tcarolus — Sat, 16 Nov 2024 19:40:46 GMT

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

Re: Rename fields useing original fieldname

miskinmaz — Thu, 14 Nov 2019 09:55:08 GMT

I guess you need to do it manually only.

Workaround will be to copy the fieldlist in excel and to use excel function to concat the string and then again copying this column in qlik script.

Re: Rename fields useing original fieldname

tcarolus — Thu, 14 Nov 2019 15:04:37 GMT

Thnx for your reply! I guess that is the only option faster than typing it manually 😉

Grz, Tamarah

topic Re: Rename fields useing original fieldname in QlikView

Rename fields useing original fieldname

Re: Rename fields useing original fieldname

Re: Rename fields useing original fieldname