| Excerpt |
|---|
Uses one row from the dataset sample as the header row for the table. Each value in this row becomes the name of the column in which it is located. |
This transform might be automatically applied as one of the first steps of your recipe. See
Initial Parsing Steps.
| Info |
|---|
NOTE: If source row number information is not available due to changes in the dataset, this transform may not be available. |
| D code |
|---|
| header sourcerownumber: 4 |
Output: The values from Row #4 of the original dataset are used, if available, as the names for each column. If the row is not available, the specified row data can be retrieved, and the transform fails.
| D code |
|---|
header sourcerownumber: row_num |
| Token | Required? | Data Type | Description |
|---|
| header | Y | transform | Name of the transform |
| sourcerownumber | N | integer (positive) | Row number from the original data to use as the header. If not specified, the current row #1 is used. |
| Include Page |
|---|
| sourcerownumber Parameter |
|---|
| sourcerownumber Parameter |
|---|
|
If no sourcerownumber parameter is specified, the first row in the dataset is used for the header values.
Example:
| D code |
|---|
header sourcerownumber: 4 |
Output: Uses row #4 from the source row numbers of the sample as the header the columns.
| Required? | Data Type |
|---|
| No | integer (positive) |
| Include Page |
|---|
| EXAMPLE - SOURCEROWNUMBER Function |
|---|
| EXAMPLE - SOURCEROWNUMBER Function |
|---|
|
| D s also |
|---|
| label | wrangle_transform_header |
|---|
|
