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

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

What is the expression used in the Assign Activity?

1 Like

image
This is the expression I used.

1 Like

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

4 Likes

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

1 Like

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

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

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

1 Like

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

1 Like

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

1 Like

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

1 Like

This is working for me

image

Reset your test data and try

Thanks,
Prankur

3 Likes

Ok @PrankurJoshi

1 Like

Thank You, It’s working fine.

HI @Karuna,

Can you close the topic if its working for you.

Hi @anil5

Please let me know how to close the topic.

1 Like

For every post you have the option like the below image

image

Sorry, I am not getting any image like this.