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

 

 

you should group by on key using UI (for example) in this way:

 

  • DDON's avatar
    DDON
    Frequent Visitor
    5 years ago

    Thanks for your reply, as far as I can tell the Group GUI only allows operations on one column. In scenario 1 I am not really interested in the max of R but which V is on the same row as th max of R.

     

    Sorry if I am missing something in your reply

    • 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