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.
