Hi I have store some duplicate value in column Name, But when I used the activity then I got the error.
Excel Data
Hi I have store some duplicate value in column Name, But when I used the activity then I got the error.
Excel Data
Fine try with this statement in assign activity
yourdatatablename = yourdatatablename.DefaultView.ToTable(True,“yourcolumnname”).CopyToDatatable
Cheers @balkishan
Means bro. First I have to read this file. using Excel Application Scope and Read Range
But @balupad14 has used only his single activity bro. i am not sure using excel application scope will this activity work.
So where I have to pass this assigned variable?
datatablename?
usually to remove duplicate rows we use two activities
–first we wiil read the data from excel with read range activity and get the output with a variable named outdt
–then we can use either of the activity
like we can REMOVE DUPLICATE ROWS where we will be mentioning the datatable name alone and output with a same datatable name been passed and if so we will getting a datatable with all the duplicates rows removed
OR
we can use DEFAULTVIEW method, and the main reason to use this here is we can remove the duplicates in the specified columns alone where as in the above method it will look in whole table
–so if the datatble named outdt
then in assign activity
outdt = outdt.DefaultView.ToTable(True,“ColumnName”).CopyToDatatable()
simple isnt it
Cheers @balkishan
Hi @balkishan,
Here I have attached the solution to you.
balkishan.zip (17.6 KB)
And also . Take a look this one.
Regards
Balamurugan.S