Assign - the source contains no data row - problem with extracting data from empty datatable

Help Studio
1

Hello. I have problem with assign activity. I have two datatables, which I compare to each other. I don’t have rows in any of them process i returning message “Assign - the source contains no data row - problem with extracting data from empty datatable”.

image
image1098×443 14.7 KB

Regular situation is that I don’t have to have data every time, but don’t know how to force assign activity to get empty datatable.

2

Before that you need to Check the count of rows
for this
Count=DT.Asenumerable.Count(Function(r) conditionPart)

if Count>0
Then
Next Step

3

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

4

Why is it returning me this error when I’m trying to use what you suggested

image
image1479×268 11.9 KB

5

Put this linq in the if activity and replace the CopyToDatatable with Any method and if it’s going to then block it means the linq is satified and you can put you assign activity in else block you can do whatever you want.

This way you can prevent this error.

6

I don’t understand. Could you, please, write down example that is based on my question?

image
image1098×443 14.7 KB

7

Use an If to check that there is data in both datatables.

8

Hey @Olivera_Kalinic,

Do it like this for both the datatables.

image
image712×340 12.2 KB

Thanks,
Sanjit

9

That causes the LINQ query to be processed twice. Just do dt.Rows.Count >0 in the If condition to make sure it has data.

1 Like
10

Ok, but in case I get no data, is it possible to write down some “0” values in destination excel files?

11

@Olivera_Kalinic
you got several inputs including the firstAid sheet which is guiding you to rewrite the CopyToDataTable into a toList and evaluating based on the count if CopyToDataTable or Clone is to execute.

Regarding to your LINQ a String.IsNullOrEmpty(yourString.Trim()) would handle more strict and greedy the blank check

Does this not solve your case?

12

Please, could you be more specific? :).
I didn’ understand anything :slight_smile:

13

did you read?
🚑 🆘 [FirstAid] Handling of The source contains no DataRows exception?

what is unclear after reading?

14

Of course. Just do those steps in the Else block of the If.

15

When trying to do those steps, I’m getting the error bellow

image
image1416×265 13.6 KB

What is strCCFilter?

16

When I’m trying to assign list of data rows to resultP variable, getting this error:

image
image1492×225 16.9 KB

What trying is to create list of Data Rows from dt1Upareni.AsEnumerable.Where(Function(x)Not (String.IsNullOrEmpty(x(“Uparivanje”).ToString) or String.IsNullOrWhiteSpace(x(“Uparivanje”).ToString))).CopyToDataTable

17

in the tutorial the steps are explained at an example and can be applied to the individual case. For sure it is not about replacing the own statement with the tutorial code.

sure done in this way it will not work
grafik

As mentioned in the tutorial

grafik
grafik898×183 14.6 KB

then
grafik
grafik720×158 9.23 KB

then
grafik
we changed copytodatatable to ToList and assigned it to variable Result

finaly we check the Count of the Result (which is a list of datarows) and use Copytodatatable or cloning the origin datatable

grafik
grafik905×567 39.8 KB

1 Like
19

Does anyone haave opinion about this post?

20

Hi @Olivera_Kalinic ,

Can you try the below in IF condition

YourDatatable.AsEnumerable.ANY(Function(x) X(“DtColumnName”).Contains(String) Or any candition you want to validate against column)

Sample : dtSample.AsEnumerable.any(Function(x) x(“Code”).Tostring.Contains(“FR”))

The above expression will result in a Boolean.

If the condition is true , then use the expression in the snapshot provided by you
If the condition is false, Then you can clone the datatable which will give you an empty data table.

Hope This Helps !