Input-row Values: V[ … ]

Owned by Morten Lindequist Køhler
Feb 14, 2024
1 min read

Use to get values of other columns from the Input-row.
Sometimes it is necessary to access multiple column-values, e.g. to concatenate several values into one column or perform calculations involving more columns etc.
Returns the value of the specified column-name from the current Input-row.

Syntax

object V[string colName]

Example

Below example shows how to prefix an ItemNumber with SupplierID, e.g. in order to create a unique key across items from several suppliers (since they may otherwise have conflicting Item-numbers).

// prefix an ItemNumber with the SupplierID Value = V["SupplierID"] + "-" + V["ItemNumber"];