2 Replies Latest reply: Feb 13, 2017 7:01 AM by Sunny Talwar RSS

    Dynamic Field Name!

    Rangaraju Rajappan

      Hi Techies,

       

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

        

      RISK_SCORE_FIELD_NAMEActual_Field_Name
      F1SLNUM
      F7SEP16
      F10OCT16
      F13NOV16
      F16DEC16
      RiskRisk
      Threshold 1Threshold 1
      Threshold 2Threshold 2
      WeightWeight

       

      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.