Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

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

Avatar

Avatar
Level 1
mani_bhimeswara
Level 1

Likes

0 likes

Total Posts

1 post

Correct Reply

0 solutions
View profile

Avatar
Level 1
mani_bhimeswara
Level 1

Likes

0 likes

Total Posts

1 post

Correct Reply

0 solutions
View profile
mani_bhimeswara
Level 1

20-04-2016

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.

Accepted Solutions (0)

Answers (0)