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?