Forum Discussion

vaidyarm's avatar
vaidyarm
Contributor
5 years ago

Does "Group By" Snap looks into what's in other fields when asked to group on the basis of just one field?

I have encountered an issue, where group by snap is not grouping data simply on the basis of the field specified. it actually looks into each document before place it under the group section of the o...
bojanvelevski's avatar
bojanvelevski
Valued Contributor
5 years ago

Hi @vaidyarm ,

Sorting the data on the same field, before using Group By will fix your problem

  • vaidyarm's avatar
    vaidyarm
    Contributor
    5 years ago

    Does Group BY Snap have any limit that how many documents it can keep under group? after we sorted the input data?

    • bojanvelevski's avatar
      bojanvelevski
      Valued Contributor
      5 years ago

      The Sort snap doesn’t dictate how many records will the Group snap keep in one group. As the name suggests the Sort snap, sorts the incoming documents.

      Group by requires clean, ordered data to do it’s magic.