Hello Everyone
Good day!
In the below table, I wanted to count if the record has duplicate with the criteria of ‘Name’ only. My logic/activity is like this…
- Read Range
- Filter Data Table (see below image for the logic)
- If (dt.rows.count > 1) then “duplicate” else “not duplicate”
However, the count of rows is always 0. Am I doing something wrong?
ID | Name | Age |
---|---|---|
1 | James | 25 |
2 | James | 25 |
3 | James | 25 |