Help me asap

kuths · Post by **kuths** » Fri Dec 18, 2009 1:30 am

Hi,

I am getting files from 2 source, each sending some data.
My job is to take these 2 files and identify a row starting from 98 as shown below in each of the file.

File1: 98,123000000,12,12
File2: 98,123,12,12

Now the data after the first comma(,) is amount and I need to add them and finally generate a new file with the value as below. I don't know the exact length of bolded values since its amount field.

Final File: 98,123000123,12,12

Please advice me.

gssr · Post by **gssr** » Fri Dec 18, 2009 1:54 am

You can use the Aggregator Stage with first column as key and get the sum of the second column

ray.wurlod · Post by **ray.wurlod** » Fri Dec 18, 2009 3:02 am

"Help me asap"? If you tell us what asap means as a verb, then perhaps we may be able to help one or more ways in which you can, actually, asap.

DSXchange is an all-volunteer site whose members post when and if they can. It is not a substitute for official support. We do not do "urgent" in any form and, indeed, find it offensive. If you want "urgent" or "asap", sign up with your support provider for priority service, and learn just how much "urgent" costs.

chulett · Post by **chulett** » Fri Dec 18, 2009 8:06 am

Why would you think you'd need to know the "exact length"? It's just a csv file, the Sequential File stage will worry about that.

ray.wurlod · Post by **ray.wurlod** » Fri Dec 18, 2009 2:59 pm

Sort funnel the rows from the two sources then use Aggregator stage as suggested. If you only want 98 as output, use a Switch, Filter or Transformer stage to effect the desired filtering.