3 Replies Latest reply: Aug 17, 2016 9:38 AM by Deepak Sharma RSS

    Classify data from Multiple Mixed fields

    Deepak Sharma

      Hi

       

      Please assist in getting the below output

       

      In Table A

      We are getting fullpath field where country name for India in coming 2nd split and for US in 3rd (FX and EX column got swaped)

      Please see the below table for more clarity

      FullPathABCDFBalance
      GBM/IND/EQ/Portfolio1/D1GBMINDEQPortfolio1D1555
      GBM/IND/EQ/Portfolio2/D2GBMINDEQPortfolio2D2666
      GBM/IND/EQ/Portfolio3/D3GBMINDEQPortfolio3D3777
      GBM/IND/EQ/Portfolio4/D4GBMINDEQPortfolio4D4888
      GBM/FX/US/Portfolio5/D4GBMFXUSPortfolio6D5999
      GBM/FX/US/Portfolio6/D6GBMFXUSPortfolio5D6111

       

      I want the below output. So that US and india will come in same column

      FullPathABCDFBalance
      GBM/IND/EQ/Portfolio1/D1GBMINDEQPortfolio1D1555
      GBM/IND/EQ/Portfolio2/D2GBMINDEQPortfolio2D2666
      GBM/IND/EQ/Portfolio3/D3GBMINDEQPortfolio3D3777
      GBM/IND/EQ/Portfolio4/D4GBMINDEQPortfolio4D4888
      GBM/FX/US/Portfolio5/D4GBMUSFXPortfolio6D5999
      GBM/FX/US/Portfolio6/D6GBMUSFXPortfolio5D6111

       

      Many thanks in advance