Special

PropertyExpressionDescription
Special
Data(name)
Returns the row data in column name. For example, if the Process this expression is used in is reading data from a table that contains a column named "ID", then the following expression would return the value in that column for the current row - such as 23701: Data("ID") If there is no column name matching the name parameter, an empty string is returned.
Special
System(name)
Returns the named system data value specified. Aside from your own data that the Process is actually moving from place to place, you may wish to refer to some of the meta data that Conductor make available that describes the job. For example, the following expression returns the date and time that the Process was executed – such as "23 Jul 2017 14:30:00.000": System("BatchExecuteDate) Unlike the Data function, System data won’t change row-by-row and will remain constant throughout the execution of the Batch. See Appendix A for the full list of System Data available.
Special
RowIndex()
Returns the current row number, starting from 1. It is important to note that the order in which rows are read from the source data store is what dictates the row numbering here. This order is usually the same as how you would view this data through other means, but depending on the source data platform this may not always be the case. This number applies after any filtering has been done – filtering will not cause gaps in the numbering sequence. For example, if the following expression is run on the 3rd row of your table, it would return 3: RowIndex() This function does not require any parameters but you do need to include the empty parentheses as shown so that it is recognised as a function.