Skip to main content

Query Task to output statisics

Comments

1 comment

  • Permanently deleted user

    Don't mean to dig up an old thread (you probably have this solved by now), but I encountered it while researching a similar task.

    In the supplied workflow, the field "ID" (fieldName variable) is specified as the Group By fields for Statistics parameter for the Query Task, but it's also included in the outStatistic parameter.  This causes all IDs to be returned since the query task was specified as "I want to group the IDs by unique IDs".  If a different field (i.e. Name ) is specified for the Group By fields for Statistics parameter, the results should be grouped by Name, and the max ID for each unique Name value should be returned. 

    0

Please sign in to leave a comment.