Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

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