Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
bismart
Creator
Creator

Generate a column name from multiple field contents on record

Hi

I would like to create a column name based on the content of 2 fields on the record currently read.

Example below... what I want is Generated field name 

field name created as follows:  “FX_Rate_” + CURR field value + ABF field value

thanks in advance

Dave

 

Sample Table input

ABF

CURR

                 Rate

 

Actual

EUR

1

 

Actual

GBP

0.82

 

Actual

USD

1.3

 

Budget

EUR

1

 

Budget

GBP

0.84

 

Budget

USD

1.4

 

Output

 

   

Generate this field name

Rate

  

FX_Rate_EUR_Actual

1

  

FX_Rate_GBP_Actual

0.82

  

FX_Rate_USD_Actual

1.3

  

FX_Rate_EUR_Budget

1

  

FX_Rate_GBP_Budget

0.84

  

FX_Rate_USD_Budget

1.4

  
    

 

Labels (2)
1 Solution

Accepted Solutions
bismart
Creator
Creator
Author

Hi Vegar

Thanks for your response.

Not really what I wanted... this just creates a field called NewFieldName with the values containing different combinations of record values.

I resolved it myself by using a Generic Load 

thanks

Dave

View solution in original post

3 Replies
Vegar
MVP
MVP

Load

'FX_Rate_' & CURR & '_' &ABF as newFieldName

...

bismart
Creator
Creator
Author

Hi Vegar

Thanks for your response.

Not really what I wanted... this just creates a field called NewFieldName with the values containing different combinations of record values.

I resolved it myself by using a Generic Load 

thanks

Dave

Vegar
MVP
MVP

Oh, I missunderstood/missread your question. I see that when re-reading it.

I'm glad you figured out how to solve your issue.

For future reference I can recommend this blog post by HIC when considering
the generic load approach.
https://community.qlik.com/t5/Qlik-Design-Blog/The-Generic-Load/ba-p/1473470