AnsweredAssumed Answered

How can we transpose the data in Boomi and back to original format?

Question asked by ukamble361217 on Jan 23, 2017
Latest reply on Jan 23, 2017 by Pavan_Sirasanambedu

Below is my input file

 

Original Format

Provider IDNameCF1CF2CF3CF4
1P1AABBCCDD
2P2PPQQRRSS

 

Question 1 : I want to convert above data in below format, how can we do that in Boomi ?

 

Format 1

Provider IDCFValue
1CF1AA
1CF2BB
1CF3CC
1CF4DD
2CF1PP
2CF2QQ
2CF3RR
2CF4SS

 

Question 2 : Also after processing (after adding some exception column) in above format 1, I want to convert data in original format, how can we do that in Boomi?

Outcomes