Setting Global Variables

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

Steps to add global variables in Datameer:

1. Open the Admin tab in Datameer.
2. Select Variables from the side menu.
3. Click New Variable.
4. Enter a variable name and value.
5. Click the checkmark icon under the Operations heading to save the variable.

Editing Variables

 Steps to edit global variables in Datameer:

1. Open the Admin tab in Datameer.
2. Select Variables from the side menu.
3. Click the pencil icon under the Operations heading in the row of the variable to edit.
4. Edit the name and/or value for the selected variable.
5. Click the checkmark icon under the Operations heading to save the edited variable.

Deleting Variables

 Steps to delete global variables in Datameer:

1. Open the Admin tab in Datameer.
2. Select Variables from the side menu.
3. Click the trash icon under the Operations heading in the row of the variable to delete.
4. Click Ok.

Searching Variables

Above the list of variables is a search bar. 

Enter a string into the search bar. The returned list are all variables that have a match to the entered string. The search feature is case insensitive. 

Using Variables

Variables can be called to use when entering file paths and within workbooks. Calling the variable name uses the assigned value.

Syntax used to call a variable

Example

Enter the file path for an import job:

File path used:

Using variables in workbooks

Documentation on using variables within workbooks.