The source contains no datarows (no data)?

Help Activities
, ,
1

Hello,

I have question sometime after filter don’t have data , so it error as below.

dt_Output = dt_Input.AsEnumerable().ExceptBy(dt_Report.AsEnumerable().Select(Function(r) r("sr1").ToString),Function(r) r("SR").ToString).CopyToDataTable

image
image775×271 33.2 KB

Please guide me for solve it.

2

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

3

Hi,

Can you try as the following?

arrDr =dt_Output = dt_Input.AsEnumerable().ExceptBy(dt_Report.AsEnumerable().Select(Function(r) r("sr1").ToString),Function(r) r("SR").ToString).ToArray

Then check arrDr.Any(). If there is datarow, use CopyToDataTAble method.

Also check the following post.

Regards,

4

@Yoichi How to choose datarow.array ?

image

5

First, choose Array of T

image

Next, choose Browse for Types

image

Finally, Choose DataRow

image
image1426×752 23.4 KB

Regards,

1 Like
6

choose Array of T
browse for types then select data row

1 Like