12. Add results of one Selection to the results of another Selection - Data Action Append

note the scenario below uses data from the deselect demo data package see docid 5 cozdtg0nwmlmeufrmbz scenario you have a data extension that already contains data, and want to add the results of your selection to the same data extension without overwriting the data already present selection 1 first, we're going to create our first data extension with data on the selections overview screen, click on new to create a new selection 1\ input drag data extension deselect demo accounts to the selected data extensions section add a filter by drag dropping field number of employees from the available fields section to the filters section choose criteria smaller than and enter 50 2\ output hit the create data extension button, enter a name, eg accounts target, and press save select the following fields by either double clicking on them or dragging them to the section on the right company name and number of employees from deselect demo accounts click save data extension 3\ preview when you click run preview on the preview screen, a results table will be shown with fields company name and number of employees from deselect demo accounts you'll see that all accounts shown have less than 50 employees now hit the run button (not run preview) to write the results to your newly created target data extension you're now being redirected to the selections overview screen where you can see the status of the selection change as it runs once completed, your target data extension will contain the results of this selection selection 2 next, we're going to create a new selection of which we want to add the results to the existing target data extension on the selections overview screen, click on new to create a new selection 1\ input drag data extension deselect demo accounts to the selected data extensions section add a filter by drag dropping field number of employees from the available fields section to the filters section choose criteria greater than and enter 100 2\ output select the target data extension you created while working on the selection in the previous steps under selection 1 click on the gear icon on the right to open the settings menu, select set data action , choose append, and finally select by setting the data action to append, the results of this selection will be added to the data already present in the target data extension 3\ preview when you click run preview on the preview screen, a results table will be shown with fields company name and number of employees from deselect demo accounts you'll see that all accounts shown have more than 100 employees note that the results shown in the preview screen are the results of your current selection, which will be added to your target data extension the preview screen does not show the data already present in the target data extension now hit the run button (not run preview) to write the results to your selected target data extension you're now being redirected to the selections overview screen where you can see the status of the selection change as it runs once completed, your target data extension will contain the results of your previous selection as well as the results of this selection