Generate a column name from multiple field contents on record

[bismart]

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

[Vegar]

Load

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

...

[bismart · Accepted solution]

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]

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