Assign: The source contains no DataRows Error

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)

@Sirisha_Siri

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…

HI @Sirisha_Siri

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

hi @Gokul001


still getting same error. can u pls check and let me know where i am going wrong

@Sirisha_Siri

(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

1 Like

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.