How to achieve concatenate the records from flat file?

Question

I have two codes in the text file( 001 & 002) if row starts with 002 code the row amount should be added with the next 001 code row amount. The sequence should be repeated for each 001 code row. means every 001 code row amount should be the sum with the previous 002-row amount(i.e b/w each 001 code row the amount should be concatenated with next 001-row amount)

Actual rows from the input file

001 | 0.00

002 | 10.5

002 | 5.0

001 | 0.00

002 | 15.0

001 | 5

002 | 7

001 | 2

Expected output rows from the input file

001 | 0.00

002 | 10.5

002 | 5.0

001 | 15.5 ( adding amount with 2nd, 3rd-row amount)

002 | 15.0

001 | 20.0 (adding amount with previous 002 code amount)

002 | 7.0

001 | 9.0  (adding amount with previous 002 code amount)

Answer 1

Script Component (transformation): Mark Col1 as read only Mark Col2 as Read/Write

The trick here is that you need to store information outside of row processing so you need to declare variables outside of row processing.

Outside of Row Processing

//these are established on the first pass and used on every row moving forward.
decimal first002;
decimal last002;
int ctr=0;

inside row processing:

if(Row.Col1=="001")
{
    //Do something with COl2 based on ctr
    switch(ctr)
    { 
        case 0:
             break; //don't do anything
        case 1:
             Row.Col2 = first002;
             break;
        case 2:
             Row.Col2 = first002+last002;
             break;
        default:
             Row.Col2 += last002;
             break;
    }
}
else
{
   //this is a 002 and need to update variables.
   ctr++
   if(ctr==1)
   {first002 = Row.Col2;}
   else
   {last002 = Row.Col2;}
}