AnsweredAssumed Answered

Need to split the countries covered by semicolon and then create one record for each country

Question asked by subbareddy.kalluru683933 on Jul 17, 2017
Latest reply on Jan 9, 2018 by shiva.karna753248

 Need to split the countries covered by semicolon and then create one record for each country Using Dell Boomi

 

Source data
addendumidclass a discountclass b discount...Class c discountcountries covered
11110%0%nullIndia, finland, australia
data to be converted and loaded to new table
addendumidclasscountrydiscount
111AIndia10%
111AFinland10%
111AAustralia10%
111BIndia0%
111BFinland0%
111BAustralia0%

 

Please suggests.

Outcomes