...
- 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:Code Block Store_Nbr, Item_Nbr, WM_Week~POS_Cost
...
| Pattern Type | Description | Example | |||||||
|---|---|---|---|---|---|---|---|---|---|
| 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: /^\d$|^\d\d$/ |
...
| Delimiter group | Description | ||||
|---|---|---|---|---|---|
| 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. |
...
