Forum Discussion
Anonymous
4 years agoNot applicable
Filtering on specific conditions
Hello everyone, I have a table that looks as per below. I would like to filter the table on the condition whereby if there are multiple rows of the same material, it will filter those wit...
- 4 years ago
Anonymous is there a logic why it's the 2nd or you just one to remove one of them?
Also, why did you remove 3-00335-53? did you mean the one above?
Basically you can just use the remove duplicates on that column and it will only keep one of them. You can sort it before that step by another column for maybe the sorting logic you need and it will keep always the upper ones
SpartaBI
4 years agoCommunity Champion
Anonymous is there a logic why it's the 2nd or you just one to remove one of them?
Also, why did you remove 3-00335-53? did you mean the one above?
Basically you can just use the remove duplicates on that column and it will only keep one of them. You can sort it before that step by another column for maybe the sorting logic you need and it will keep always the upper ones