AnsweredAssumed Answered

Pivot flat file

Question asked by MikeLaVigne2981 on Aug 30, 2017
Latest reply on Nov 20, 2017 by 51662476

Hello community, 

 

i have a flat file document like below: 

 

Document IdColumn NameColumn Value
S123456Project NameArgus
S123456Project StatusGreen
S987654Project NameLegion
S987654Project StatusRed
S987654Project Start Date8/30/2017

 

Every time the integration runs, the output will be different, depending on which column is recently changed. I want to be able to make it to: 

 

Document IdProject NameProject StatusProject Start DateProject End Date
S123456ArgusGreen
S987654LegionRed8/30/2017

 

I understand it is not possible to have a dynamic profile in Boomi, but any other suggestions that can make this happen? The number of fields (columns) is fixed. 

 

Any suggestion is appreciated! 

Outcomes