Object ID Inclusion

brady
brady Member
in Datasets

I am building a table where I only want to include items with a singular row for object_ID. In my dataset, when an item is created, a row is created, denoting the action as 'Created'. This object is also given an ID. When that object is updated or altered in any way, a new row is created, indicating the object has been 'Updated'. This item retains the same ID, as it is the same item, just slightly altered now. In my table, I only want to include items that do not have multiple rows for the same ID. I only want the items that have 1 row, indicating that they have not been altered in any way.

What would be the best way to go about this?

Best Answer

  • MarkSnodgrass
    MarkSnodgrass Coach
    Answer ✓

    I would use a group by tile and put your object id in the first section and then in the aggregate section, do a count of object ids. This will tell you how many rows you have of each. You can then add a filter tile and filter to where your count equals one. You can then use a join tile to join it back to your original dataset and join on object id if you need the full row details of those object ids.

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.

Answers

  • MarkSnodgrass
    MarkSnodgrass Coach
    Answer ✓

    I would use a group by tile and put your object id in the first section and then in the aggregate section, do a count of object ids. This will tell you how many rows you have of each. You can then add a filter tile and filter to where your count equals one. You can then use a join tile to join it back to your original dataset and join on object id if you need the full row details of those object ids.

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.

Categories