Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hello Rangaraju,
Please try using Alt(expr1 { ,Expression}) function.
Thank you!
Rahul
May be check the link out: