I have been unsuccessfully trying to use tmap as the last part of a process, which I will summarize as follows:

The process extracts information from a Cobol proprietary system, w/o table maps.

As a result the only information available is in the form of a print formatted report.

The Java process have different sub jobs that do: a) clean headings b) create a row counter c) separate info (positional rows) according to 4 criteria (agent info, customer info, invoice info, transactions info). d) create 4 tab delimited files e) reassemble the files as tab delimited using the row counter as guide.

All successful. I end with a file looking like this(summary):

Record    Record_type   Agent       Customer   Invoice    Transactions
1                 1              aaaa     
2                 2                             xxxxxx
3                 3                                             FV-001
4                 99                                                            00111
5                 99                                                            00228
6                  1             bbbb
7                  2                           yyyyyy   
8                  3                                            FV-002
9                  99                                                           00879

fields Record and Record_type are integer. Agent, Customer, Invoice and Transactions are String. Table is sorted by Agent, Customer and Invoice.

I have been unable to create a way in tmap to update the table rows in a way that keeps the first agent name while the agent name is null or empty string in the input flow and updates to the new agent name as input row agent is not null or not empty string:

tFileInputdelimited ---> tmap --> tFileOutputDelimited

Record    Record_type   Agent       Customer   Invoice    Transactions
1                 1              aaaa     
2                 2              aaaa          xxxxxx
3                 3              aaaa                         FV-001
4                 99            aaaa                                         00111
5                 99            aaaa                                         00228
6                 1              bbbb
7                 2              bbbb          yyyyyy   
8                 3              bbbb                        FV-002
9                 99            bbbb                                         00879

I have already searched throughout the forum and checked several related threads w/o success. Any help would be really appreciated .