Manage Tables

Once you have created your extraction, you will be automatically directed to the Tables window.

By default, no table is listed. This is from this window you define the data you want to retrieve from the source through the use of tables or SQL queries.

Adding Tables

  1. In the upper left hand corner, click on New and select Add Tables.
  2. In the Choose your tables window, select the table from which you want to use the data and click on Save.
Note

You can use the search bar as a filter, select multiples tables by using the Ctrl and Shift keys or with a mouse drag.

By default, when you add a table, all their fields are also included. To refine your selection and thus define the fields to include from those to exclude, you can refer to Setup the Field Section for more details.

According to the type of extraction you selected (refer to the explanation given in Add an Extraction for more details), you can change the table destination name by clicking directly in the cell of the Table destination column you want to change then on Save.

Note

In the case of a Migration extraction type, you will be restricted to choose a name among the existing values in the drop-down list.

For the Export extraction type, there are no restrictions regarding the file extension used by the Destination table (.txt, .doc, etc). If no file extension is specified, the .csv file format will be generated by default.

Tip

You can change multiple tables and only press the Save button once to apply changes to them all.

Applying a Filter

From this page, you can apply a filter to any table or query (refer to Add a SQL Query for more details). All you need to do is click on the pencil icon when hovering over a row of the Filter column then enter your SQL query in the SQL Expression Builder window.

Purging Tables

Available only for Migration extraction type, this feature allows you to clean the table based on a condition before importing new data.

In other words, it gives you the possibility to remove some existing data in the Table via a condition.

To use this feature and define the condition:

  1. Under the Purge Condition column, hover on the cell and click on the pencil.
  2. In the pop-up window, click on Confirm.
  3. In the SQL Expression Builder window, enter your condition and click on Save.
Example

 

DELETE FROM [DESTINATION_TABLE]
	WHERE <PURGE_CONDITION>

                                                        
If the purge condition is: [CITY] = 'Toronto',
			this will result in:
DELETE FROM [DESTINATION_TABLE]
	WHERE [CITY] = 'Toronto'

                                                    

                                                    
Duplicating a Table

                                                    
As for the Purge Condition feature, Duplicating a Table is only available for Migration extraction type. It extracts all information about the Table to duplicate and its Fields. The Table and Field entities (Filter and Query) will then obtain a new ID and the Table will have its Destination Table deleted.

                                                    
    
                                                        
  • Select the table you want to duplicate in the list and click on the Duplicate Table icon.
    • 
                                                    

                                                    
Example 
                                                        
Let's say you want to use the same Table to retrieve different data via a Query. Instead of starting from scratch, the only things you would have to do would be to change the filter and the Destination Table.