Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Rename fields useing original fieldname

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

  

1 Solution

Accepted Solutions
Highlighted
Creator III
Creator III

Hi 

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.

View solution in original post

2 Replies
Highlighted
Creator III
Creator III

Hi 

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.

View solution in original post

Partner
Partner

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

Grz, Tamarah