Getting the error when remove the duplicate

Hi I have store some duplicate value in column Name, But when I used the activity then I got the error.
image

Excel Data
image

@Palaniyappan @balupad14

1 Like

can i have a view on the property panel of remove duplicates activity
Cheers @balkishan

1 Like

image

1 Like

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

1 Like

yes exactly buddy
Cheers @balkishan

1 Like

But @balupad14 has used only his single activity bro. i am not sure using excel application scope will this activity work.

1 Like

So where I have to pass this assigned variable?

datatablename?

1 Like

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

4 Likes

Buddy @balkishan

1 Like

Hi @balkishan,

Can you please attach the XL Please

Regards
Balamurugan.S

1 Like

File1.zip (5.6 KB)

sorry for the delay @balupad14

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

1 Like

Thanks @balupad14 sure I will see this :slight_smile:

1 Like