Variable Applications
Variables allow you to pair a chosen name with a specified value. You can then recall the value of your variables in your data statements as many times as you need using the name you assigned to it.
Say you have a variable named @City with the value of Toronto. Now, rather than writing Toronto numerous times throughout your SQL statement, you can replace it with the @City variable. That way, if you ever decide to change Toronto (e.g., to Toronto, ON), you would simply change the value of @City, and it would instantly update every occurrence of the variable within your statement.
Some common variable applications in DataSync include:
- Creating customized filters and queries
- Purging tables (migration extractions only)
- Calculating data within a field
To formulate variables in DataSync, you must type an @ symbol followed by the variable's name as shown in the example below:
The main Variables page (shown below) lists all variables that are currently applied to any of your extractions at the Fields level.
For more information on actions that can be performed on the Variables page, see Adding/Editing/Removing Variables.