AnsweredAssumed Answered

Hello

Question asked by venkatesh.rupanagudi080702 on Sep 23, 2016
Latest reply on Sep 27, 2016 by venkatesh.rupanagudi080702

Hello Guys,

 

I'm new to Boomi community. I work with Hi Tech Company using Boomi for Integration. I have a question regarding appending of  record in a file . I have input file and Out file listed below.

 

Input File :

 

So ODS tables will have data like this:
SHIP_FROM        ITEM                    PLAN_ARRIVAL_DATE                QTY    FORECAST NUMBER    SHIP_TO
1111000502      ACK-404-01-C    2016-11-03 00:00:00.000     0               WBF20160100000000000001       1060
1111000502      ACK-404-01-C    2016-12-15 00:00:00.000     100           WBF20160100000000000001      1060
1111000502      ACK-404-01-C    2017-02-16 00:00:00.000     0               WBF20160100000000000001       1060
1111000502      ACK-404-01-C    2016-11-03 00:00:00.000     0               WBF20160100000000000002       1030
1111000502      ACK-404-01-C    2016-12-15 00:00:00.000     0               WBF20160100000000000002      1030
1111000502      ACK-404-01-C    2017-02-16 00:00:00.000     500           WBF20160100000000000002       1030

 

Output File

 

1111000502      ACK-404-01-C    1060 WBF20160100000000000001xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx(loop)161103000000000000161215000000000100170216000000000000……..
1111000502      ACK-404-01-C    1030 WBF20160100000000000002xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx(loop)161103000000000000161215000000000000170216000000000500……..

 

I need to roll up the Output for the QTY field based on SHIP_FROM/ITEM/Forecast Number/Ship_To as key.  Essentially the first 4 records will be rolled up into 1 record and Forecast Number is same for first 4 input records.

 

Any suggestions how to make it in Boomi ?.

 

Thanks very much for your time

Venky

Outcomes