Index
Create column(s) with an incremental index. e.g. 1,2,3...
Create a new incremental index.
Parameters
| Name | Description | Accepted Values | Default | Required |
|---|---|---|---|---|
| I/O | ||||
output | Name or list of names of new columns. | string, array | — | Yes |
by | Optional. Cluster the created indexes by one or more columns. | string, array, null | null | No |
| Options | ||||
start | (Optional; default 1) Starting number for the index. | integer | 1 | No |
step | (Optional; default 1) Step between successive rows. | integer | 1 | No |
| Conditions | ||||
if | Condition that determines whether the wrangle runs as a whole. Recipe variables may be referenced with ${variable}. | string | — | No |
where | Filter rows before applying the wrangle using SQL-like criteria, such as column1 = 123 OR column2 = 'abc'. | string | — | No |
where_params | Values used with where for parameterized criteria. Uses SQLite placeholder syntax such as ? or :name. | array, object | — | No |
Examples
wrangles:
- create.index:
output: New Index
start: 1 # optional
step: 1 # optional
No sample available.
| New Index |
|---|
| 1 |
| 2 |
Access
| Requirement | Value |
|---|---|
| AI-powered | No |
| Requires WrangleWorks account | No |
| Requires subscription | No |
| Requires external API key | No |
Technical details
| Field | Value |
|---|---|
| Catalog ID | 17 |
| Catalog key | create.index |
| Recipe key | create.index |
| Catalog status | active |
| Lifecycle status | active |
| Recipe Writer eligible | Yes |
| Namespace | create |
| Documentation group | create |
| Aliases | None |
| Runtime symbol | wrangles.recipe_wrangles.create.index |
| Legacy UUID | 0a4909ca-6e14-4da7-8a70-a7fd106d6944 |
Sources