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.
Table of Contents |
---|
Adding Variables
Steps to add global variables in Datameer:
- Open the Admin tab in Datameer.
- Select Variables from the side menu.
- Click New Variable.
- Enter a variable name and value.
- Click the checkmark icon under the Operations heading to save the variable.
Editing Variables
Steps to edit global variables in Datameer:
- Open the Admin tab in Datameer.
- Select Variables from the side menu.
- Click the pencil icon under the Operations heading in the row of the variable to edit.
- Edit the name and/or value for the selected variable.
- Click the checkmark icon under the Operations heading to save the edited variable.
Deleting Variables
Steps to delete global variables in Datameer:
- Open the Admin tab in Datameer.
- Select Variables from the side menu.
- Click the trash icon under the Operations heading in the row of the variable to delete.
- 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
Panel |
---|
${<variable name>} |
Example
Variable name | Variable value |
---|---|
Quarter_1 | Q1 |
...
Panel |
---|
Users/Business/Customer/Product/Q1/Sales.csv |
Using variables in workbooks
Documentation on using variables within workbooks.
...