Hi , I am a newbie to datastage and stuck on this job since yesterday
Can someone help me with this
My data after transforming looks like below:
JobId Status
------------------
7859 Success
7859 Fail
7859 Success
7859 Success
I want my output data to look like:
JobId Success Fail
-------------------------
7859 3 1
The JobId does not differ and is consistent for all the records.
I tried aggregator stage but i am grouping on jobid, status and doing count rows which gives me the below output
JobId Status Count
--------------------------
7859 Success 3
7859 Fail 1
Converting column data into Columns and performing count
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 6
- Joined: Mon May 06, 2019 6:42 am
Converting column data into Columns and performing count
nikita bandekar
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: Converting column data into Columns and performing count
If you have a Transformer already in the job, you could use that with LOOPING logic inside the Transformer itself and get the count directly for each JobId (if you find Aggregator and Pivoting combination becomes heavy)