Hi I am trying to remove duplicates rows of a column using LINQ query, till yesterday it gave me proper output…Todayi am getting the error when trying to execute assign block.
Error : Assign: The source contains no DataRows.
please find my code and sample excel. pls help me
ErrorsOutput_24_3_2022.xlsx (59.4 KB)
VLookupForComments.xaml (18.8 KB)
This error usually occurred when provided expression didn’t return any return Data Rows. Can you please check input file and provided expression once.
Hi @lakshman
i checked, expression was correct only…also i gave direct folder path and checked. still i am getting same error. Could u pls check the workflow and help me…
Try this expression
(From p in dtData.Select() where( From q in dtData.Select() where q("GUID").Equals(p("GUID")) Select q).ToArray.Count=1 Select p).ToArray.CopyToDataTable()
Regards
Gokul
There is no Unique value in the GUID Column this may the reason for the error @Sirisha_Siri
Regards
Gokul
(From d In dtData.AsEnumerable
Group d By k=d("GUID").toString.Trim Into grp=Group
Where grp.Count =1
Select grp.First()).CopyToDatatable
Instead of = 1 try with > 0
Hope this may help you
Thanks
Thankyou so much @Srini84 . it worked
DT.Asenumerable.Groupby(Function(r) r(col_idx)).select(Function(D) D.First).CopytoDatatable
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.