“remove the duplicate rows from excel in UiPath” , can you give me correct answer , how can solve the problem ?
Hey @UJJVAL_BHAGAT
Take a Assign activity!
dt_Input = dt_Input.DefaultView.ToTable(True)
Try Once above LinQ will give you expected output!
Regards,
Ajay Mishra
On excel:
On dataTable (all Cols are used for the duplicate rating):
Method: ToTable(True ← method argument
YourDTVar.DefaultView.ToTable(True)
LINQ Operator
AllCols: YourDTVar.AsEnumerable().Distinct(DataRowComparer.Default)
Defined Col(s)
just name a few options of possible more options
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.