Pervasive

Hi,

I have following data in source file.

rno rname amount

--- -------------- ------------

1  s  2000

2 d  3000

3 a  4000

But i need target file like this

1   s   2000  9000

2    d   3000  9000

3    a   4000  9000

 

Thanks in Advance.............

You'll need to provide additional details if you want to get a better response. There's unfortunately not much to work on. Its looks like you might be working with an Ascii and need additional spaces between each record. Could you provide information on your Source and Target? Is this actual data from your target output?

Hi,

Thanks for your suggession.

i have the source data(ASCII delimited) like follows.

 Record No  Account No  First Name    Payment

 1                 10019            Bobbi             100.00

 2                 10023           Bruce              120.00

 3                 10024           Bruce              125.00

 4                  10025          Butch              130.00

 5                  10026          Calla                135.00

--------------------------------------------------------------------------------------

In Target file (ASCII File) i need output as follows

 Record No  Account No  First Name    Payment     SumAmt

 1                 10019            Bobbi             100.00         610.00

 2                 10023           Bruce              120.00         610.00

 3                 10024           Bruce              125.00         610.00

 4                  10025          Butch              130.00         610.00

 5                  10026          Calla               135.00         610.00

------------------------------------------------------------------------------------------

In target SumAmt filed displays a value is sum of Payment Field of all records(100+120+125+130+135=610).

 

Thanks,

Sudhakar

Process the file twice from a process? Once with a NULL output target that adds up the amounts and sets the process variable, the second time use that process variable in your last column.

Hi,

 Thanks a lot for answer. I have one question. Is it possible on map designer? or should i use process designer? Please let me know.

 

Thanks,

Sudhakar.

Could be done easily in a map. Just store the sum in a variable and the source fields in a djRowset. At the end (onEOF), write out all your records from the rowset.

http://docs.pervasive.com/products/integration/di/wwhelp/wwhimpl/js/html/wwhelp.htm#href=rifl/DJRowSet_Object_Type.html

There are many ways to do this. But all of them include making two passes over the data. This could be done in two maps. The First map aggregates all the data from "Payment" into a single variable lets call it pSumPayment. The Second Map will remap the data from the source to a new target that has a new field called sum payment. The target field expression for sum payment will always return the value in pSumPayment. You might also want to account for special cases such as null or zero as well.

How can i write DJRowSet records to target file at EOF? The target file is ascii file.

 There is an onEOF event in the Source General event handlers. That's where you add your ClearMapPut action. Use the rowset.size in the count parameter of your ClearMapPut. Write something in the CounterVariable parameter like cntr. In your target field expression, to grab the first field in the rowset - your expression would be rowset.value(cntr,1).

Hi,

 

Thanks a lot.