Error Linq query

[vittoria]

Hi all,

we have read range activity and assing with linq query.
In attached the file input
File input.xlsx (8.9 KB)

Below the query used

dtInputProva.AsEnumerable().Where(Function(row) Not dtFinal1.AsEnumerable().
Select(Function(r) r.Field(Of String)(“Concat”)).Any(Function(x) x = row.Field(Of String)(“Concat”))).
CopyToDataTable()

when we execute this workflow we have this issue

Could you support us?

Thanks
Vittoria

[lakshman (Ganta lakshman)]

@vittoria

Welcome back to our UiPath community.

We will get this error usually when if we don’t have any matching rows with the given condition.

[supermanPunch (Arpan)]

Hi @vittoria ,

Take a look at the below post to handle that Error/Exception :

[FirstAid] Handling of The source contains no DataRows exception

This FirstAid Tutorial will describe how a the source contains no DataRows EXCEPTION can be handled. Introduction Let’s have a look at the following filter data table scenario: Name CCode Tom US Charlotte FR Seema IN Jean FR Assignment: Filter all rows on a particular Country Code like FR, UK, ES, UK… Ensure that all CCode data column values are trimmed Ensure that the Filter check is case insensitive we can implement it e.g. with the help of a LINQ statement: dtData.As…