Why do I get the error?
What I’m trying to do is:
I have a data table called work_database_mainfilters, I need to split this data table in three separate data tables in order to do some advanced filtering, and then I need to merge these three back into one again.
This is my workflow:
Do you have any ideas?
A row can only be in one DataTable at a time. If you want the same data in more than one DataTable, you will have to
copy the data into a new DataRow and add the new row instead
When using Add Datarow activity
give a try:
use instead of DataRow:CurrentRow
Add List as Row: CurrentRow.ItemArray
I don’t understand.
So I start off with this main filters data table,
and then I’d like to end up with merged data table.
How do I do that? If the row can’t be in two data tables at the same time is it possible to delete my first data table or something? (Sorry for stupid questions)
as mentioned above: using the CurrentRow.ItemArray
We assume that you are working at StudioX otherwise there would be also the Merge DataTable activity
Yes… merge data table ehhh. Thanks
Hey, what can I do if one of my data table that I want to merge is empty? I get Object reference not set to an instance of an object. error. and I would like this to be ignored
initialize it before with: YourDTVar = new DataTable()
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.