Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago
Solved

Grouping

Hello, I have a table with the following columns: 1. Operation Id 2. Id Paso 3. Date I need to get a table grouped by Operation ID, getting the most recent date and its respective Step ID. W...
  • v-jingzhang's avatar
    v-jingzhang
    4 years ago

    Hi aperezd 

     

    Do you want something like this? 

     

    First group by operation id column and add two new columns as below. The Latest Date column will return the latest date for every operation id. 

     

    Then expand the All Rows column and select only necessay columns to expand. 

     

    Add a step to filter rows where [Date] = [Latest Date].

     

    Remove Latest Date column if it's not needed any longer. I have attached the sample file at bottom. 

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

v-jingzhang's avatar
v-jingzhang
Community Support
4 years ago

Hi aperezd 

 

Do you want something like this? 

 

First group by operation id column and add two new columns as below. The Latest Date column will return the latest date for every operation id. 

 

Then expand the All Rows column and select only necessay columns to expand. 

 

Add a step to filter rows where [Date] = [Latest Date].

 

Remove Latest Date column if it's not needed any longer. I have attached the sample file at bottom. 

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.