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.
