12 Replies Latest reply: Aug 11, 2016 10:36 AM by Fayez Khan RSS

    Dynamically Concat the fields alphabetically

    Fayez Khan



      I need to concatenate different fields in my load script alphabetically leaving other fields unchanged.



      Field AField BField CField DConcatMeasure
      Tom SayerDarren RoachJay KempnerDon BurtonDon BurtonDarren RoachJay KempnerTom Sayer4000




      The desired output will be Concat field in the above example. It is basically shifting the fields left to right or vice versa alphabetically without effecting other fields.