How do I sum amounts based on run date parameter

[farkeye]

Hi, I am very new to all of this good stuff.

I am working with a sequential file as input that contains
Amount_1 Decimal Length 13 Scale 2
Amount_2
.
.
.
Amount_12

There is also a Job Parameter : Datecard_From_Date with default value
2007-02-01

Based on the Job Parameter with month of 02 I only want to sum Amount_1 and Amount_2 into a new column.

Question: What stage do I use and of course how do I code it?
Would setting up the input as an occurs make it easier ?

[pbatchu]

Use the transformer stage. You can use parameters in transformer and also if condition. You can use if condition to assign value to new column. Make sure that you handle nulls, if not transform stage may drop records.

[farkeye]

Use the transformer stage. You can use parameters in transformer and also if condition. You can use if condition to assign value to new column. Make sure that you handle nulls, if not transform stage may drop records.

Thank you, I will give that a try.