Find count Each department Number.

vijayasarathi7 · Post by **vijayasarathi7** » Fri Jan 31, 2014 3:13 am

Hi All,

I have a job, I want the count of the Each department number.
Source File:
DEPTNO, SAL
10, 1000
10, 1100
10, 1200
20, 1100
20, 1200
30, 1200
30, 1300
30, 1400

Target File:
Count
1
2
3
1
2
1
2
3

Thanks,
Vijayasarathi

ray.wurlod · Post by **ray.wurlod** » Fri Jan 31, 2014 4:31 am

Why "without using Aggregator"?

This can be done simply using key change detection techniques and stage variables, as has been discussed many times on DSXchange.

RPhani · Post by **RPhani** » Fri Jan 31, 2014 4:42 am

Hi,

You can get the required o/p by If -Then- Else with KeyChangeColumn(1 and 0) and StageVariables.

----------------------------
RPhani

rkashyap · Post by **rkashyap** » Fri Jan 31, 2014 8:45 am

I would imagine that you will also need DEPTNO in the Target File for the output to be useful.

priyadarshikunal · Post by **priyadarshikunal** » Thu Feb 06, 2014 7:17 am

interview question?