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


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!