How does Alteryx Summarize Tool group by work?

[pyalx]

I am using a Summarize Tool and on that I am using the Group By

it is like this:

Field        Action           Output field name

Col1         Group By      Col1

Col2         Group By      Col2

Col3         First              Col3

Col4         Group By     Col4

Col5         First              Col5

Does it first group by and then do First, FIrst

or Group By , First, Group By and then First?

[SPetrie · Accepted solution]

Group, Group, First, Group, First.

Its a cascade. First it will group all items in Col1, then it will Group each Col2 items with respect to the Col1 groups it just created, then it will take the first Col3 item with respect to the Col1+Col2 groups, then group items in Col4 with respect to the first three groupings created, and then the first of Col5 again with respect to the previous 4 groups created.

[geraldo]

@pyalx 

Get the first line in the sequence that the data is in the table of the group to be aggregated
You putting the group by between the first columns will only change the order that the data will be shown in the output.

input:

1o case:

2o case

[pyalx]

Thanks for composing the answer. So, you are saying that the values wil still be the same either way we do group by.

eg: 

Group By, Group By, Group By,  First, First

Group By, Group By, First, Group By,  First

will both produce same result?

[geraldo]

@pyalx 

Yes.
that's right.