"This row already belongs to another table" Error message

Main.xaml (12.8 KB)TestingDataTable_Merge.xlsx (10.3 KB)

I am practising my skills on datatable manipulation.
And I dont seem to understand how to use the add data row function.

Please take a look at the workflow and let me know why the above said error occur?

Thanks alot people!

Tower

Hi @Towerboy

See below sample

Main (6).xaml (8.1 KB)

Filtered.xlsx (7.5 KB)

Let me know if this is what you are looking for

Thanks,
Prankur

2 Likes

Yeah Exactly!
So what I am missing is the “CopyToDataTable” command.

Few follow up questions below:

  1. So the command basically combined array of datarows to form a datatable?

  2. Regarding my original workflow, I was wondering what’s the correct way to add a whole line of data row to a new data table?
    For example, adding a data row to a new data table.

  3. The filter data table function from Uipath is not working 100% of the time, is that normal?

Thanks for the quick reply PrankurJoshi! Appreciated. Sorry for having more questions. Thank you.

Regards
Tower

1 Like

Here is same thing with Add Data Row

Main (6).xaml (12.6 KB)

Ans3. Filter data table works just fine, if not check the conditions.
Ans2. You are in a loop and copying the same row on what you are working that was the error
Ans1. Returns a Datatable that contains copies of Datarow objects

Thanks,
Prankur

3 Likes

Thanks a lot Joshi!
Last question, is there a way that I could add those header back in the final output with this method?

Thanks for the quick reply! :slight_smile:

Check the Add Headers option

Thanks,
Prankur

1 Like

Oh I thought after the dt.selet command, the header was lost…

Sorry about that. Thanks!

1 Like

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