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
|header||Y||transform||Name of the transform|
|sourcerownumber||Y||integer (positive)||Row number from the original data to use as the header.|
header sourcerownumber: 4
Output: Uses row #4 from the source row numbers of the sample as the header the columns.