Solved! Go to Solution.
I'm going to answer to your first use case scenario.
Please see the Screenshot JOB.
As you can see, I'm using tMap, tAggregate and tSort jsut to make the data sorted like you have in your OUtput sample. I haven't made any specific functions rather than using classical operation.