Assign:The source contains no datarows?

[supermanPunch (Arpan)]

@Vanitha_VS

(
From row In UAT_Competency_DT_new
Let exists = Prod_competency_DT.AsEnumerable.Any(Function(x) x(“Expand AllCollapse All”).ToString = row(“Expand AllCollapse All”).ToString)
Select If(exists, Prod_competency_DT.Rows.Add({}), row)
).CopyToDatatable

Hi @Vanitha_VS ,

Could you let us know what are you trying to perform using the Linq mentioned ?

Also, Could you check the below post on resolving errors when Direct CopyToDatatable is used :

[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…