Hi Team,
In my work flow, I have a data table (workDates), which is been created as a result of a read range activity. Then I use the below code to assign in to the same data table variable WorkDates as;
WorkDates.Rows.Cast(Of DataRow)().Where(Function(row) Not row.ItemArray.All(Function(field) field Is DBNull.Value Or field.Equals(“”))).CopyToDataTable()
to get rid of the empty rows it retrieves and it works perfectly fine.
But when I try to copy the workflow into another new sequence (even after copying all relevant variables), it gives error saying that “copy to data table is not a member of system.collections.generic.IEnumerable(Of System.Data.Datarow)”
I’m not sure why it’s giving this error while it perfectly fine for the other work flow. Could you please help me on this?
Thanks.
Piyumi