Array DataRow cannot be converted to DataTable

Help
1

I have this assignation:

assign
assign1105×577 33.7 KB

After that I have a For Each Row

for
for1109×567 33.2 KB

When I execute this sequence appears this:

"Compiler error(s) encountered processing expression “filteredRows”.
Value of type ‘1-dimensional array of System.Data.DataRow’ cannot be converted to ‘System.Data.DataTable’.

What can I do?
Thanks

2

You were almost done
FOR RACH ROW can take only datatable as input
But when select method is used it gives us array of datarow
So just a small change
All with that expression
Use a assign activity before to the for each row loop and mention like this

*yourdatatable = Yourdatatable.Select(“expression”).CopyToDatatable()

Mention the CopyToDatatable
Then mention that datatable name in for each row loop

Cheers @Natalia_Lozano

3

Appears a Runtime execution error:

runtime

4

What he says is to Add .CopyToDatatable after your sampleData.Select(“vvvv”) assign…

5

@Natalia_Lozano ,

"Object reference not set to an instance of an Object " - This error comes when something is not defined and trying to get value out of it.

In your workflow what i can observe is that , you are using foreach with array of datarow. Instead you should convert it to datatable and then you can use…
For converting datatable – sampleData.Select(“Age <40 and Income>40K”).CopyToDatatable you can use.

Still i have attached one sample for your reference, have a look…

Arrayofrowtodatatable.xaml (9.1 KB)
Test Excel.xlsx (7.9 KB)

Ahtesham