This row already belongs to another table error... what do I do wrong?

Help StudioX
,
1

Hello

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:

image
image303×731 28.1 KB

image
image386×813 31.5 KB

image
image405×737 25 KB

Do you have any ideas?

The error:
image

2

@anon40731888,

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

3

When using Add Datarow activity

give a try:

  • use instead of DataRow:CurrentRow

Add List as Row: CurrentRow.ItemArray

4

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)

5

not needed

  • as mentioned above: using the CurrentRow.ItemArray

We assume that you are working at StudioX otherwise there would be also the Merge DataTable activity

6

Yes… merge data table ehhh. Thanks

7

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

8

initialize it before with: YourDTVar = new DataTable()

9

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