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