Forum Discussion

DDON's avatar
DDON
Frequent Visitor
5 years ago
Solved

Data maniplulation after grouping

Happy Friday!   I am trying to extract data specific for each group from one column in a table based on finding the maximum value in another column.   I have the following setup Key = column by ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

     

    try using this M-expression

     

     

     

     

    then expand column records:

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

 

try using this M-expression

 

 

 

 

then expand column records:

 

DDON's avatar
DDON
Frequent Visitor
5 years ago

Perfect. Thanks for your time on that. I think I understand the syntax of the solution apart from the "_". If you have a moment could you explain what that is up to or point me towards the documentation.

 

Thanks again