Solved: How to control the order when grouping

yishenhui · ‎06-14-2023

Hi,

When I grouping, is it poosible to control the order of aggregation? As below two screenshots, the first step, the data is already sorted. But when I grouping and want to combine those string together with this order, it doesn't. Any idea how to get it?

Thanks

Payeras_BI · ‎06-15-2023

Hi @yishenhui ,

I would try this:

Table.Group(Table.Buffer(SortTableAgain),...

If this post answered your question, please mark it as a solution to help other users find useful content.
Kudos are another nice way to acknowledge those who tried to help you.

J. Payeras
Mallorca, Spain

View solution in original post

Payeras_BI · ‎06-15-2023

Hi @yishenhui ,

I would try this:

Table.Group(Table.Buffer(SortTableAgain),...

If this post answered your question, please mark it as a solution to help other users find useful content.
Kudos are another nice way to acknowledge those who tried to help you.

J. Payeras
Mallorca, Spain

yishenhui · ‎06-15-2023

Hi J.Payeras,

I applied a sorting in the source date loading. After that, the issue disappeared even I removed the sorting. I cannot re-produce the issue again to test your suggestion. But I have read the articles about Table.Buffer and would accept it as Solution.

Thanks.