i have a flat file document like below:
|Document Id||Column Name||Column Value|
|S987654||Project Start Date||8/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 Id||Project Name||Project Status||Project Start Date||Project 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!