If there are identical numbers in Excel, display only one Help me

image
before

image
after

Please tell me how to output only one column if it’s the same column
Thank you in advance.

@22222222asas

Read the datatable and then use remove duplicate rows activity

Output will have only unique values

Alternately use assign like this uniquedt = dt.DefaultView.ToTable(True,"Number")

Both would work

Cheers

1 Like

Hi,

Another simple approach: can you try Remove Duplicate activity?

Sample
Sample20231124-3.zip (14.5 KB)

Regards,

1 Like

Hi @22222222asas ,
It need remove duplicate only
have many way
my input
image

my output
image

my code
RemoveDuplicate (2).zip (9.5 KB)

Regards,

1 Like

@Yoichi
Thank you for the response, but I think my explanation was a bit incorrect.
“No. 1 Can we leave the duplicate values as they are in Excel, and No. 2 Can we move only the Excel data where duplicate values have been removed?”

ex)
image

@Nguyen_Van_Luong1
Thank you for the response, but I think my explanation was a bit incorrect.
“No. 1 Can we leave the duplicate values as they are in Excel, and No. 2 Can we move only the Excel data where duplicate values have been removed?”

ex)
image

@Anil_G
Thank you for the response, but I think my explanation was a bit incorrect.
“No. 1 Can we leave the duplicate values as they are in Excel, and No. 2 Can we move only the Excel data where duplicate values have been removed?”

ex)
image

Hi @22222222asas ,
I have updated
we need add “Header”
image
that’s right?
my updated source
RemoveDuplicate.zip (9.6 KB)

Oh, no this’s not correct
Can you please clear your requirements
with value 1, we need keep, and value2 remove?
that’s right?
regards,

1 Like

Hi,

If you need to create new sheet which has only unique number, the following will work.

Sample
Sample20231124-3 (2).zip (14.6 KB)

Regards,

1 Like

@22222222asas

After reading the data just write it to a new sheet…the above formula are still intact

Cheers

@Yoichi
Thank you very much for your response. However, what I am looking for is, instead of moving the sheets, can I write the results to another Excel file?

From no.1.xlsx to no.2.xlsx

Thank you in advance

@Nguyen_Van_Luong1
Thank you very much for your response. However, what I am looking for is, instead of moving the sheets, can I write the results to another Excel file?

From no.1.xlsx to no.2.xlsx

Thank you in advance

HI,

How about the following?

Sample
Sample20231124-3 (3).zip (14.6 KB)

Regards,

Hi @22222222asas ,
We can filter data table base on value
or split data to multi data base on value
then write each data to other file
RemoveDuplicate.zip (23.9 KB)

regards,

1 Like

@Yoichi
Thank you for your good response!

1 Like

@Nguyen_Van_Luong1
Thank you for your good response!

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