Help with a data table split

Hi, what’s up?
I need help with the following context:
I have a data table with 500,000 rows and it generates a spreadsheet in Excel. I need to generate 2 different Excel files based on the same data table.
Here’s what I did: I created a copy of the original data table and cleaned the data, leaving only the header, and then I try to pass to the empty copy the half to the end of the original data table, deleting the rows that were passed.
But every time I go to add the row to the copied data table, it returns the error “This row already belongs to another table”.

Can anyone help me?

1 Like