![Sad :(](./images/smilies/icon_sad.gif)
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