DSXchange

Hi LakshmiNarayanan,

Could you please explain us how to achieve the end result using Aggregator stage?

Thank You,

Thank You Jwiles. It solves my issue. Just I want to add little bit explanation to it. If the Filter stage contains two where clauses 1) Dept=10 2) EmpName=ABC and the option= OutputRow only once. Then the output of 1st where clause (Dept=10) get two rows, but the 2nd where clause (EmpName-ABC) get ...

Hi, I am trying to use the filter stage to output the data. The structure of the job is SeqFile -----> Filter ----> SeqFile My source data looks like as described below. EmpNo EmpName DeptNo 1 ABC 10 2 BCD 20 1 ABC 10 In the filter stage I set the where clause as DeptNo=10 and selected the Option=Ou...