Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Community is experiencing an influx of spam. As we work toward a solution, please use the 'Notify Moderator' option on the ellipsis menu to flag inappropriate posts.

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
21 - Polaris

@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