- Multiple: Select one or more discrete columns from the drop-down list.
- All: Select all columns in the dataset.
- Range: Specify a start column and ending column. All columns inclusive are selected.
Advanced: Specify the columns using a comma-separated list. You can combine multiple and range options under Advanced. Ranges of columns can be specified using the tilde (
~) character. Example:
Store_Nbr, Item_Nbr, WM_Week~POS_Cost
|Literal value||An exact string or value.|
The following matches on the exact value between the quotes:
The following matches when two digits appear at the beginning of a value:
|Regular expression pattern|
Regular expressions are a standard method of describing matching patterns.
The following matches on all numerical values from 0 to 99:
|On delimiter||Transformation is applied based on a specific literal or pattern.|
|Between delimiters||Transformation is applied on database between two literal or pattern-based delimiters. Details are below.|
|On multiple delimiters|
Transformation is applied based on a sequence of delimiters. An individual pattern can be a string literal,
|Between positions||Transformation is applied based on a starting index position and an ending index position. Index positions start from 0 on the left side of any cell value.|
|On positions||Transformation is applied based on a sequence of listed index positions. Index positions start from 0 on the left side of any cell value.|
|At regular interval||Transformation is applied at every nth position. Index positions start from 0 on the left side of any cell value.|