Post reply

No CountIff feature in aggregate task?

  • November 2, 2009 at 5:24 pm

    #156365

    Hi all,

    There's no CountIff feature in aggregate task? I have data in one of my dataflow columns of my data flow component in which the data is arranged by status (ie "A", "P", "O"). I basically just want to do a column each for Countiff "A", Countiff "P", and Countiff "O". I was thinking this would be on the aggregate task, but this is only limited to Group By, Count, and Count distinct.

    I did what I needed in a script component flow just to get it done, but it just seems like there should be a bunch of different aggregations (average, countiff, sum, etc.) to use in the aggregate task, but its only these three. Even though I did it my way I just wanted to see what people do for these types of aggregation situations?

    Thanks,

    Strick

  • November 3, 2009 at 12:25 am

    #1074130

    stricknyn (11/2/2009)

    Hi all,

    There's no CountIff feature in aggregate task? I have data in one of my dataflow columns of my data flow component in which the data is arranged by status (ie "A", "P", "O"). I basically just want to do a column each for Countiff "A", Countiff "P", and Countiff "O". I was thinking this would be on the aggregate task, but this is only limited to Group By, Count, and Count distinct.

    I did what I needed in a script component flow just to get it done, but it just seems like there should be a bunch of different aggregations (average, countiff, sum, etc.) to use in the aggregate task, but its only these three. Even though I did it my way I just wanted to see what people do for these types of aggregation situations?

    Thanks,

    Strick

    I'm assuming that neither the source nor the destination is SQL Server, otherwise a combination of COUNT and GROUP BY would seem to get you there straight away.

    Can you give slightly more detail about how you want the output to look? Additional column or columns, or sorted in a certain way?

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply