Forum Discussion

mikeoshields's avatar
mikeoshields
Helper I
7 years ago
Solved

Parent/Child Table Filtering

I'm sure this answer is already in here but I haven't found it yet.  I have two tables in a parent/child relationship.  When I pull a single record from the parent, I want to also get all of the fields in the row from the child that is related by ID and where the timestamp = max(timestamp).  Any help would be appreciated.

 

 

  • sturlaws's avatar
    sturlaws
    7 years ago

    Hi mikeoshields ,

     

    you can add a isMaxTimestampFlg-column on the many-side of you relationship, i.e. 1 for the rows where timestamp=max(timestamp), and 0 elsewhere. Then you would just have to add this column to the filter section of a visual and filter for isMaxTimestampFlg=1.

1 Reply

  • sturlaws's avatar
    sturlaws
    Resident Rockstar
    7 years ago

    Hi mikeoshields ,

     

    you can add a isMaxTimestampFlg-column on the many-side of you relationship, i.e. 1 for the rows where timestamp=max(timestamp), and 0 elsewhere. Then you would just have to add this column to the filter section of a visual and filter for isMaxTimestampFlg=1.