Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

D toc
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 s
snippetBasic

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 s
snippetParameters
D code

header sourcerownumber: row_num

TokenRequired?Data TypeDescription
headerYtransformName of the transform
sourcerownumberNinteger (positive)Row number from the original data to use as the header. If not specified, the current row #1 is used.

D s lang notes

sourcerownumber

Include Page
sourcerownumber Parameter
sourcerownumber Parameter

If no sourcerownumber parameter is specified, the first row in the dataset is used for the header values.

Info

NOTE: In some cases, the source row number information might no longer be available. See SOURCEROWNUMBER Function.

 

Example:

D code

header sourcerownumber: 4

Output: Uses row #4 from the source row numbers of the sample as the header the columns. 

D s
snippetusage

Required?Data Type
Nointeger (positive)

 

D s
snippetExamples

Example - Header from row that is not the first one

Include Page
EXAMPLE - SOURCEROWNUMBER Function
EXAMPLE - SOURCEROWNUMBER Function

D s also
labelwrangle_transform_header