Dynamic Field Name!

[rajuamet]

Hi Techies,

I have a list of field names and their alias names.

RISK_SCORE_FIELD_NAME	Actual_Field_Name
F1	SLNUM
F7	SEP16
F10	OCT16
F13	NOV16
F16	DEC16
Risk	Risk
Threshold 1	Threshold 1
Threshold 2	Threshold 2
Weight	Weight

I will concat RISK_SCORE_FIELD_NAME records and store it in a variable to load the respective fields from a Source table.

For Example:

LET vFieldList = '[' & peek('RISK_SCORE_FIELD_NAME') & ']';

Data_Source_Filtered:

LOAD

    $(vFieldList)

FROM

SOURCE_TABLE ;

But, after loading I need to rename these fields with the records from 'Actual_Field_Name'.

How do I achieve this.

[rahulpawarb]

Hello Rangaraju,

Please try using Alt(expr1 { ,Expression}) function.

Thank you!

Rahul

[sunny_talwar]

May be check the link out:

How to Rename Fields