I am looking to have two separate groupings in one ETL. Is there a way to do this without having to use two Group By tiles?
Also I no longer see the minimum aggregate option for my new column. Do I now have to use the Min() formula?
@TC1199A
@TC1199A you will have to combine the data either by APPEND or JOIN depending of your needs.
@Godiepi Once I have my second Group by tile i should use a join correct?
@Godiepi It looks like it is working now. However, I want to also include the rest of my columns from my input dataset and not just the ones from the two groupings. How should I go about adding these back in?