...
The following example generates a new column containing the source row number for each row in the dataset, if available:
| d- |
|---|
...
| trans | ||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
If you have already used the $filepath reference, as in the previous example, you can combine these two columns to create a unique key to the source of each row:
| d- |
|---|
...
| trans | ||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
$col
The $col variable is a reference to the column that is currently being evaluated. This variable references the state of the current dataset, instead of the original source.
...
In the following example, all columns in the dataset that are of String type are converted to uppercase:
| d- |
|---|
...
| trans | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
In the above, the wildcard applies the edit to each column. Each column is tested to see if it is mismatched with the String data type. If mismatched, the value in the column ($col) is written. Otherwise, the value in the column is converted to uppercase (UPPER($col)).
...
