Can someone help me to remove the duplicate rows

Help Studio
, ,
1

I have a table where the row 3 and row 5 are repeated . I can only remove the row if both of these conditions satisfy: name repeats and also project ID repeats for that person.
Attaching the excel sheet for your reference

Kindly someone help me
test11.xlsx (9.7 KB)

2

Hey @shilpa_p,

Go through the below link this will help you to solve your issue.

Thanks,
Sanjit

3

Thanks. Can you please provide me the thread link

1 Like
4

Thanks a lot. I will go through

5

@shilpa_p Please go through the below workflow

Example.zip (11.8 KB)

Datatable DT1 = DT.DefaultView.ToTable(True, "Name","Proj ID")

above exp which will give the values where name and project id not repeats

Output

Capture

6

Thank you so much. It works :slight_smile:

7

if i need to mention column number instead of column name , then how should i write

8

@shilpa_p Is there any problem in giving column name

9

no in my actual file, the column name is repeated twice. So I asked. While reading that file I skip reading headers.

10

@shilpa_p Try this

DT.DefaultView.ToTable(True, DT.Columns(0).ToString, DT.Columns(2).ToString)
11

Thanks a lot :slight_smile:

12

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.