Hello everyoone.
I want to create an action that will delete one row or (more) if i have two rows or (more) with the same column value and left just one.
Can someone help me to do this please? Thank you.
Solved! Go to Solution.
You want to make sure there are no existing rows with the same ID_Equipment and Model. For this we will create a slice that contains only one row with the same unique pair. Let's name this slice uniquePairs.
Then you'll create an Action to delete all rows in your table that do not exist in the slice. This action will be configured as below:
You can display this action as an overlay button that you can click to remove duplicates or make it as a Form Saved action so that it runs whenever the form is saved.
A better approach, as @TeeSee1 said, is to prevent duplicates from happening in the first place. For this you can put the following expression in the Valid if field of both your "Model" and "Equipment_ID" columns:
ISBLANK(
FILTER(yourTableName, AND(
[ID_Equipment] = [_ThisRow].[ID_Equipment],
[Model] = [_ThisRow].[model]
))
- LIST([_ThisRow])
)
May want to implement some thing to prevent duplicate s in the first place.
Yes,
For example these two rows have the same (model) and the same (id_equipement), so i want to delete one and leave the other
I tried to do it but I didn't quite understand
You want to make sure there are no existing rows with the same ID_Equipment and Model. For this we will create a slice that contains only one row with the same unique pair. Let's name this slice uniquePairs.
Then you'll create an Action to delete all rows in your table that do not exist in the slice. This action will be configured as below:
You can display this action as an overlay button that you can click to remove duplicates or make it as a Form Saved action so that it runs whenever the form is saved.
A better approach, as @TeeSee1 said, is to prevent duplicates from happening in the first place. For this you can put the following expression in the Valid if field of both your "Model" and "Equipment_ID" columns:
ISBLANK(
FILTER(yourTableName, AND(
[ID_Equipment] = [_ThisRow].[ID_Equipment],
[Model] = [_ThisRow].[model]
))
- LIST([_ThisRow])
)
Thank you so much @Joseph_Seddik and @TeeSee1 it works well
Hi There
So how do I delete all the older timestamp in a duplicate Standard Tool ID. E,g, How to delete row 115,116 and keep the maxrow timestamp 117 with the latest date 8/15/2023 10:52:32
User | Count |
---|---|
41 | |
25 | |
25 | |
17 | |
12 |