"The source contains no DataRows" in Assignment 1 level 3

Learning Hub Academy Feedback
1

Untitled
Untitled1333×520 31 KB

Hi All, getting the above error. I checked the no.of rows in DataTable after extraction, getting 87. But getting that NO DataRows.
Can anyone help me in solving this issue.

Thanks.

1 Like
2

What is the expression used in the Assign Activity?

1 Like
3

image
This is the expression I used.

1 Like
4

Check the count of rows in Extracted Data Table, it seems there is no data in it.

If it has then try this

ExtractedDataTable.Select("[Type]='WI5' AND [Status]='Open'").CopyToDataTable

Also, Out_WIList should be array of datarows not a datatable

Thanks,
Prankur

5 Likes
5

Untitled
Untitled836×439 14.5 KB

If I convert the out_WIList to array of datarows, it is showing the above error @PrankurJoshi .

1 Like
6

If you are using Datatable.Select() it will return an array of data rows only, so in this case, do not use

.CopyTodataTable

Thanks,
Prankur

3 Likes
7

Please convert your Output variable, out_WIList to System.data.datatable and use the above select query

ExtractedDataTable.Select(“[Type]=‘WI5’ AND [Status]=‘Open’”).CopyToDataTable

1 Like
8

Untitled
Untitled1314×477 23.6 KB

Didn’t use .CopyTodataTable, getting the above result, that no rows in out_WIList.

1 Like
9

Yeah tired this too, but getting that no data rows @anil5.

1 Like
10

Can you give your xaml file, will look into it.

1 Like
11

Ok.
Calculate_Client_Security_Hash (2).zip (93.6 KB)

1 Like
12

This is working for me

image

Reset your test data and try

Thanks,
Prankur

4 Likes
13

Ok @PrankurJoshi

1 Like
14

Thank You, It’s working fine.

15

HI @Karuna,

Can you close the topic if its working for you.

16

Hi @anil5

Please let me know how to close the topic.

1 Like
17

For every post you have the option like the below image

image

18

Sorry, I am not getting any image like this.