AnsweredAssumed Answered

Split db column

Question asked by nakumar532024 on Sep 20, 2016
Latest reply on Sep 20, 2016 by nakumar532024

I have a requirement to get the records from the db table which has two column and split the value in Column A using delimiter (,) and insert into each record in another table.

 

For eg:

Column A has value 12,13,14,15 and Column B has value "RECORD_ID"

 

 

Results should be:

Column A                  Column B

12                              RECORD_ID

13                              RECORD_ID

14                              RECORD_ID

15                              RECORD_ID

 

How to achieve this in boomi?

Outcomes