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)
Go through the below link this will help you to solve your issue.
Thanks. Can you please provide me the thread link
Thanks a lot. I will go through
@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
Thank you so much. It works
if i need to mention column number instead of column name , then how should i write
@shilpa_p Is there any problem in giving column name
no in my actual file, the column name is repeated twice. So I asked. While reading that file I skip reading headers.
@shilpa_p Try this
DT.DefaultView.ToTable(True, DT.Columns(0).ToString, DT.Columns(2).ToString)
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.