Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center here.

Bring Headers to first row and fill only one cell in headers row.

7 - Meteor

Hi Team,

 

Below is the sampled data. I want the field headers to go to second row and new headers to be Props in first cell and to leave the other cells blank as shown in output.

 

Input:

Code1Code2Percent
le09iv070
le10iv080
le11iv090

 

Output:

Props  
Code1Code2Percent
le09iv070
le10iv080
le11iv090
Highlighted
Alteryx Partner

Hi,

 

The headers can't be blank in Alteryx, but you can of course add the header to the first column. And if you want to simulate blanks, you can add 1 or 2 spaces to the select tool (but they can't be identical to one another).

 

To not have column headers in first row you need to select First Row contains data in the input tool

 

Example screenshot and workflow attached. 

 

Regards,

Tom

 

Rename headers.jpg

Labels