Script Group Function

$ScriptGroup function allows users to run an external script as a data source for the group of data. The function has four mandatory parameters:

  1. Group number. Positive Integer.
  2. Column number. Positive integer.
  3. The full path and file name of the script interpreter. String.
  4. File path and name with the script without quoting*. String.

* - the following macros can be used as a part of the file name: %APPDATA%, %DOCUMENTS%, %USERPROFILE%, %ALLUSERSPROFILE%

Any number of optional parameters will be passed to the script. The column to column reference or expression call is acceptable.

The script should write generated data to standard output stream separated by tab ("\t") symbol.

Examples

  1. $ScriptGroup(1,1,c:\python33\python.exe,c:\my scripts\test.py) - Python script without extra parameters crates group #1 and returns 1st column of data
  2. $ScriptGroup(2,4,c:\python33\python.exe,c:\my scripts\test.py,Data1,10) - Python script with two parameters: 'Data1' and '10' creates group #2 and returns 4s column