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

    Dynamically Concat the fields alphabetically

    Fayez Khan

      Hi,

       

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

       

         

      Field AField BField CField DConcatMeasure
      alphaGammaBetaXetaalphaBetaGammaXeta1000
      DABCABCD3000
      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.