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.

NOTE: If source row number information is not available due to changes in the dataset, this transform may not be available.

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.

header sourcerownumber: row_num

TokenRequired?Data TypeDescription
headerYtransformName of the transform
sourcerownumberYinteger (positive)Row number from the original data to use as the header.

sourcerownumber

Example:

header sourcerownumber: 4

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

Required?Data Type
Yesinteger (positive)

 

Example - Header from row that is not the first one