For replacing an already added datatable with another datatable(“ButSameTableName”) we do have different approaches.
Some forum members preferred:
delete the table from the DataSet,
Add the other DataTable under the same tablename.
As an alternate we can exploit, the references are kept for the datatable when using assign activity:
we assigned from DataSet our “Table1” DT to dtOld
Used dtOld for clearing
Merged new data from another DataTable dtNew to the empty dtOld
DataSet.Tables(“Table1”) will then have all and only the rows from dtNew. We omitted the deletion and re-addition of datatables from dataset
One last question, do you know a way how to pass the dataset into an extraction result? I added the new data table into the dataset but need to parse the dataset back into the extraction result variable.