Improve Promote Header Selection

Promote header has been improved to include a similar options as the Range Selector node. This makes selecting a header row in your data much faster with index selection.

How Do I Add The Promote Header?

Add Promote Header to any node in your Dataflow. Select any node and use the Transform (+) button to open the list of options to select Promote Header. You could work with the node in the Dataflow tab or use the Properties panel.

‍

What Are the Options for Selecting a Header?

Promote header by index.
Promote header with conditional.

‍

1. Promote header by index.

Set a header row by selecting a row index (i.e., row 12).

‍

2. Promote header with conditional.

Select First Occurrence or Last Occurrence to create a filter condition to pick a header in the dropdown. The conditional lets you set the header row when the value in a selected field matches the given criteria in the filter.

‍