0 Replies Latest reply on Apr 20, 2016 6:15 AM by mani bhimeswaras92469638

    We have a requirement to store the column values coming in pipe separated into individual rows.

    mani bhimeswaras92469638 Level 1

      We have a requirement to store the column values coming in pipe separated into individual rows. Can this be possible to separate and store in the recipient schema using script or enrichment and How? any sample code.

       

      Ex: user group and userslist will come in one csv file where user list having data like (user1|user2|user3) where this data group user lists we need to separate as individual rows and then map to recipient table to update their usergroup. Please let us know if any additional data required.

        Usergroup  Userslist

         group1        100001|10002|10003

         group2        100003|10004|10006

       

        Store the csv file data in one schema and update the recipient table new group column with the groupid coming from csv file.