Forum Discussion

yishenhui's avatar
yishenhui
Icon for Helper II rankHelper II
3 years ago
Solved

How to control the order when grouping

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...
Need Help
  • Payeras_BI's avatar
    Payeras_BI
    3 years ago

    Hi yishenhui ,

    I would try this:

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

     

Payeras_BI's avatar
Payeras_BI
Icon for Solution Sage rankSolution Sage
3 years ago

Hi yishenhui ,

I would try this:

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

 

  • yishenhui's avatar
    yishenhui
    Icon for Helper II rankHelper II
    3 years ago

    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.