Forum Discussion

Mike282's avatar
Mike282
Icon for Helper III rankHelper III
6 years ago
Solved

Group rows, concatenate then sort concatenated value alphabetically

Hi all,   So I've got a table with rows containing item line numbers and a group ID.     I've then managed to group them together and concatenate by a delimiter following the below post: ...
Need Help
  • parry2k's avatar
    parry2k
    6 years ago

    Mike282 I think you need to use table.buffer and then group it. Similar post here.

     

     

Mike282's avatar
Mike282
Icon for Helper III rankHelper III
6 years ago

Hi parry2k ,

 

Thanks for the fast response! Still no luck. The concatenated values all concatenate together in random order.

 

Kind regards,

Mike

parry2k's avatar
parry2k
Icon for Super User rankSuper User
6 years ago

Mike282 I think you need to use table.buffer and then group it. Similar post here.

 

 

  • Mike282's avatar
    Mike282
    Icon for Helper III rankHelper III
    6 years ago

    Thanks parry2k ,

     

    That seems to do the trick! Although the table buffer function seems to also at the same time slow query performance.