Header

<< Click to Display Table of Contents >>

Navigation:  Reference > Transforms >

Header

Description

Move rows from the top of the dataset into the header.

 

Example

Append the first row to the header:

 

how to append the first row to the header example

 

Inputs

One.

 

Options

Set Top rows to move to the number of rows you want to move from the top dataset into the header. Setting it to 0 means the transform does nothing.

Set Existing header to Overwrite to ignore the existing header values and Append to add to the existing header values.

Set Delimiter to any text you want to put between column elements. It can be left empty. Ignored if Existing header set to Overwrite and Top rows to move set to 1.

 

Notes

Empty cells are ignored.

You can Sort and Filter your dataset to change the top rows.

You can add the header from one dataset to another dataset using Stack.

 

See also

Headers