Join the Alteryx Community’s Maveryx Summer Cup event! Compete, network with others, and earn your gold through a series of challenges from July 24th to August 11th. Learn more about the event here.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Create row from header

tv7988
5 - Atom

Hi, my data header contain dates. I want to de-promote that header to a normal row. How can I do that? 

 

tv7988_0-1669228151298.png

 

(red text indicates data)

5 REPLIES 5
Kakuffo
Alteryx
Alteryx

The input data tool would do this for you its about how you input the data to push the headers down check option 6 first row contains data

tv7988
5 - Atom

The problem is my data above is a output of a series of nodes in Alteryx, Input tool does not take that in

binuacs
20 - Arcturus

@tv7988 Looking for something like below

binuacs_0-1669245494636.png

 

DenisZ
11 - Bolide

If you are importing data for example from xlsx, then make sure to check "First row contains data" 

 

DenisZ_0-1669270139534.png

 

 

Hope this helps. Please mark it as solved if it solves the issue. 

 

KrishnaChithrathil
11 - Bolide

@tv7988 

How does this look?

 

Input:

KrishnaChithrathil_1-1669274346336.png

 

Output:

KrishnaChithrathil_0-1669274068439.png

KrishnaChithrathil_0-1669274314200.png

 

 

Labels