Keep structure of table as it is and take distinct row

Help
,
1

Hi All,

Below is my table structure after merging data now i want to remove duplicates from data which i am having in one data table using customer number, company code and frequency columns and want to keep all table structure as it is, please help it urgent.

image
image1173×164 5.9 KB

2

Hi @amruta_pawar

dt1 = dt.DefaultView.ToTable(true, “customer number”, “company code”,“frequency”)

3

this giving me data as 12345,2290,Custom two times, but i want only one row with all other columns.

4

May be LINQ can help but i am not good at this so needing help in that.

5

Check this linq, @amruta_pawar
dataTable new_dt =
old_dt.AsEnumerable().GroupBy(Function(i) i.Field(Of String)(“columnWithDuplic”)).Select(Function(g) g.First).CopyToDataTable

6

can you please tell me with my columns , it will be great help.

7

@amruta_pawar
dataTable new_dt =
old_dt.AsEnumerable().GroupBy(Function(i) i.Field(Of String)(“customer number”) and i.Field(Of String)(“company code”) and i.Field(Of String)(“frequency") ).Select(Function(g) g.First).CopyToDataTable

8

getting error as below,

image
image1082×309 22.4 KB

9

Don’t just copy paste the linq query, change the double quotes and your datatable at the beginning of linq query.
If possible send me your workflow and the file.

11

Check this input, output and workflow,
Ouput_Data.xlsx (7.3 KB) SampleSequence.xaml (12.8 KB) Input file.xlsx (18.6 KB)

12

hi buddy this giving me data from first dt i want output data from result dt