Assign: The source contains no DataRows Error

[Sirisha_Siri]

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)

[lakshman (Ganta lakshman)]

@Sirisha_Siri

@Sirisha_Siri

Error : Assign: The source contains no DataRows.

This error usually occurred when provided expression didn’t return any return Data Rows. Can you please check input file and provided expression once.

[Sirisha_Siri]

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…

[Gokul001 (Gokul Balaji)]

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

[Gokul001 (Gokul Balaji)]

There is no Unique value in the GUID Column this may the reason for the error @Sirisha_Siri

Regards
Gokul

[Sirisha_Siri]

hi @Gokul001

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

[Srini84 (Srinivas)]

@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

[Sirisha_Siri]

Thankyou so much @Srini84 . it worked

[Gangadhar_Athili]

DT.Asenumerable.Groupby(Function(r) r(col_idx)).select(Function(D) D.First).CopytoDatatable