before
after
Please tell me how to output only one column if it’s the same column
Thank you in advance.
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
my output
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)
@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)
@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)
Hi @22222222asas ,
I have updated
we need add “Header”
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
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 @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.