Home arrow Reference arrow RepeatTextColumnValues
RepeatTextColumnValues

This command repeats the specified script command for each unique text column value, and is typically used with a RunScript command to execute a series of commands from a script file.

Syntax:

RepeatTextColumnValues, scriptcommand 

Parameters:

scriptcommand – a script command with parameters, typically 'runscript, scriptfilename'

Examples:

prompt,add,[ThisTextColumnName],Region

RepeatTextColumnValues,Runscript,ConsolidateValues.txt 

For each unique value in the text column 'Region', run the script file ConsolidateValues.txt, passing the current text column value as the prompt [ThisTextColumnValue].

Comments

Note that the prompt [ThisTextColumnName] must be set to the text column to be processed.

 

Reference

Installation - Java