2 Replies Latest reply: Nov 14, 2014 9:20 AM by Ashfaq Mohammed RSS

    Parse Field during LOAD

    Philipp Wesseling

      Hi,

       

      my source data contains a table with just two fields:

       

      SalesProducts
      JohnFood, Goods, Electronic
      JackFood, Drinks, Games, Cars

       

      From this format i would like to create a table like:

       

      SalesProduct
      JohnFood
      JohnGoods
      JohnElectronic
      JackFood
      JackDrinks
      JackGames
      Jack Cars

       

      Some help of how i can loop through the field and extract value by value would be much appreciated!

       

      thanks,

      P