DataTable.Merge returns "Expression does not produce a value" Error

Hello

Browsing through the forums I encountered this error a fair few times, but none of the solutions seem to work in case of merging Data.Tables.


When I try to use the ‘Invoke Method’ activity I get the following error:

“‘DataTable’ does not have a public instance method named ‘Merge’ matching the parameter types, generic type arguments, and generic type constraints supplied to InvokeMethod ‘Invoke Method’.”

This is what it looks like in UiPath

image

Thanks for your time.

Have you considered using the “Merge Data Table” activity?

1 Like

Also, I think you are getting that error because your Parameters are wrong. You should have one datatable as an In argument of type DataTable.

1 Like

Thanks for your reply!

I forgot to input the parameters indeed.

The parameters should look like this:

image

Where the value (ExtractDataTable) is the DataTable that will be added.

image

And the TargetObject (FinalTable) is the DataTable that will be updated.

I’ll try out the ‘Merge Data Table’ activity as well.

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.