KNOWLEDGE BASE

Error "0 rows successfully added" Appending Data from Extract


Published: 24 Aug 2016
Last Modified Date: 07 Apr 2017

Issue

Unable to add data from one extract to another - getting "0 rows successfully added" error.

Environment

  • Tableau Desktop
  • MS SQL Server

Resolution

Save the extract as a .tde and then make an extract from the .tde file.

1) Connect to the live data source in Tableau Desktop.

2) On the Sheet1 tab right-click the data source and select Extract Data. Add the required filter (say, "Year = 2008") and click the "Extract" button.
Tableau should prompt you for the name of the .tde (extract) file: call the file "EXTRACT1" and save it on your machine.

3) In Tableau, click Data -> <Name of the datasource> -> Extract -> Remove; and select "Just remove the extract" at the prompt. This will make Tableau go back to the live connection.

4) Right-click the data source again and select Extract Data. Add the required filter (say, "Year = 2009") and click the "Extract" button.
Tableau should prompt you for the name of the .tde (extract) file: call the file "EXTRACT2" and save it on your machine.

***You can go back to step 3 as many times as needed to create an extract for each year***

5) Click Data -> New data source and connect to the EXTRACT1.tde file we created in step 2.

6) Right-click the EXTRACT1.tde data source and select Extract Data. Extract All rows. 
Tableau should prompt you for the name of the .tde (extract) file: call the file "EXTRACT FULL" and save it on your machine.

7) Right-click the EXTRACT1.tde data source and select Extract -> Append Data from Data Source. Select the second data source (the 2nd extract we created in step 4) to add data from it. 

***If more than 2 extracts were created, you can connect to all the other extract files and add data from them as described in step 7.

8) Save the workbook as a .twbx file to make sure the changes to the "EXTRACT FULL" file are saved. 
 

Cause

Extract-level filters prevent adding more data to an extract: all the new data that does not fit the filter will be discarded.
Did this article resolve the issue?