Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
tcarolus
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
miskinmaz
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
miskinmaz
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

tcarolus
Partner
Partner

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

Grz, Tamarah