How to solve the source contains no data rows?

[suraj_gaikwad]

Hello team

I’m getting this error as show in above image

I’m iterating data table with downloaded files by using this below code

“dt.AsEnumerable.GroupBy(function(x) x(“Customer Name”).ToString.ToLower.Trim).Where(function(x) Not x.Any(function(y) y(“Match Type”).ToString.ToLower.Trim.Equals(“confirmed”))).SelectMany(function(x) x).CopyToDatatable”

Code is working but the issue is the when only single row available in downloaded file and that case is ‘confirmed’ that time this issue occurred

This is the file
Again DOC-20231016-WA0016.xlsx (7.3 KB)

@Anil_G

Thanks

[Yoichi]

HI,

Can you try to use DataRow array (use ToArray method instead of CopyToDataTable) then check it contains any rows using IF, as the following post?

Error DataTable's DataRow 0

HI, Can you try as the following? arrDr = dt.AsEnumerable.Where(Function(r) Convert.ToInt32(r("Status").ToString) = 0 Or Convert.ToInt32(r("Status").ToString) >= 3).ToArray Then check arrDr.Any note: arrDr is DataRow array type [image] Regards,

Regards,

[Anil_G (Anil Gorthi)]

@suraj_gaikwad

Please try this in if condition

dt.AsEnumerable.GroupBy(function(x) x(“Customer Name”).ToString.ToLower.Trim).Where(function(x) Not x.Any(function(y) y(“Match Type”).ToString.ToLower.Trim.Equals(“confirmed”))).SelectMany(function(x) x).Count>0

and on then side use the normal assign with linq

on else side use arr_dtout = dt.Clone

Hope this helps

You are facing the error because all rows are filtered and no rows are present to copy to datatable

cheers

[suraj_gaikwad]

Thank you

@Yoichi
@Anil_G

[ppr (Peter Preuss)]

[FirstAid] Handling of The source contains no DataRows exception - News / Tutorials - UiPath Community Forum