Hi all, I have below question and tried many times but failed, would u kindly help ?
I have three datatable (dt1\ dt2\dt3), dt1 has one column “A1” ,dt2 has one column “B1”, and dt3 has no column. And how can I copy and combine column “GET” & column “EEL” to in the same column in dt3? And how to remove duplicates in dt3 ? Tks.
For example: dt1 & dt2 is my data source, and dt3 is what i want
dt1 HR dt2 Sale dt3 HR
IT GMO IT
IE IT IE
HR Sale
GMO
Did you try activities like:
Read Column, Insert Column (for excel) and Remove Duplicate Rows?
There are also activities for datatables like: Merge Data Table.
Tks Mahesh. But I can’t understand how to delete duplicated item in the list. My List_A has 6 item (HR, IT,HR,GMO,IT,SALE).When I use write line [string.Join(“,”,list_A.Distinct)], showed only 4 item (HR,IT,GMO,SALE) in List_A. Now, I want to make List_C = the distinct of List_A, how to write with assign activity ?