INFO

Datameer's global variables can be assigned values and called upon to be used within file paths and workbooks. The use of variables can help ease migration of workflows from one environment to another, as well as to provide more generalized workbooks.

Adding Variables

To add a global variable:

Open the tab "Admin" and select "Variables". All existing variables are listed.
Click "New Variable". A new row opens. INFO: The data for 'Created' and 'Modified' is automatically given, when creating a new variable.
Enter the name and value of the variable in the respective field.
Click the 'checkmark icon' to confirm. The variable is added.

Editing Variables

To edit a global variable:

Open the tab "Admin" and select "Variables". All existing variables are listed.
Click the 'pencil icon' in the row of the variable to edit or click directly in the field you want to edit.
Edit the name and/or value for the selected variable.
Click the 'checkmark icon' to confirm. The variable is edited.

Deleting Variables

To delete a global variable:

Open the tab "Admin" and select "Variables". All existing variables are listed.
Click the 'trash icon' in the row of the variable to delete. A dialog opens.
Confirm with "Ok". The variable is deleted.

Searching Variables

To search for a variable name, enter a string into the search bar. The result list contains all variables that have a match to the entered string. INFO: The search feature is case insensitive. That means you can't create and use a variable ${ABC} and ${abc}.

Using Variables

INFO

Variables can be used within file paths while import and export, within workbook formulas and filter conditions within the workbook.

Syntax used to refer to a variable

${<variable name>}

Example

Variable name	Variable value
Quarter_1	Q1

Enter the file path for an import job:

Users/Business/Customer/Product/${Quarter_1}/Sales.csv

File path used:

Users/Business/Customer/Product/Q1/Sales.csv

Using variables in workbooks

INFO

Documentation on using variables within workbooks.

Browser not supported