Data Guru parameters

In Data Guru, parameters allow you to create variables which can be used across multiple actions using a common value.

You can create parameters for a project that can then be used wherever a literal or string term can be used in an equation.

Parameter names are preceded by @@ and enclosed in square brackets, such as @@[ParameterName], to identify them within Data Guru.

Using parameters for external files or data sources

You can use parameters to identify the following files and sources:

• SQL Server Connection
  • Server Name
  • Hosted Database Name
  • Attachable Database File Path
• Excel Spreadsheet Connection
  • File Path
• Delimited File Connection
  • File Path
• Delimited File Export action
  • File Path (for output file)
• Excel Spreadsheet Export action
  • File Path (for output file)
  • path

For example, you can use a parameter with a value that identifies the location and name of an Excel file for an Excel Spreadsheet connection or Excel Spreadsheet Export action.

Parameters and regional settings

For data formats affected by a computer's regional setting, you can use parameters to represent the data. If a project that includes these parameters is transferred to a computer in another region, the values for these parameters are represented in the appropriate regional format.

Formats affected by regional settings include the following data types:

• DateTime

  For example, if your computer's regional setting uses mm/dd/yyyy, and you define a DateTime parameter with a value of 10/01/2018, when you transfer that project to a computer with a date format of dd/mm/yyyy, the value of that parameter is interpreted correctly as 01/10/2018.

• Decimal

  For example, if your computer's regional setting uses n,nnn.nn, and you define a Decimal parameter with a value of 1,222.10, when you transfer that project to a computer with a Decimal format of n.nnn,nn, the value of that parameter is interpreted correctly as 1.222,10.

If these parameters are used to filter data or in the Expression Editor, the value is interpreted correctly in those instances as well.