Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Want to pick specific row as a header

Srawat
8 - Asteroid

Hi,

 

Could you please let me how I can pick the yellow highlighted row as a header row in alteryx.

 

Srawat_0-1663930693151.png

 

 

Thanks,

 

8 REPLIES 8
Felipe_Ribeir0
16 - Nebula

Hi @Srawat ,

 

1)If the header of the files can be in any row:

 

a)Configure the input tool to get this file

b)Use the filter tool to filter column C != null and column C != "" (or any column that can be used as reference to keep the header and the data)

c)Use the dynamic rename tool configured to take field names from first row

 

Felipe_Ribeir0_0-1663930920543.png

 

2)If the header of the files is always on the same row, just configure the field Start Data Import on Line of the input tool to get the header from this row

FrederikE
13 - Pulsar

Hey  @Srawat

Choose the desired line in the input Tool. 

 

Unbenannt.png

Emmanuel_G
13 - Pulsar

Hi @Srawat 

 

Find attached the way of doing that.

 

Emmanuel_G_0-1663931234696.png

 

Srawat
8 - Asteroid

It is working fine however unable to get correct header please refer filter and then dynamic tool and advise. Thanks.

 

Srawat_0-1663933318982.png

Srawat_1-1663933335989.png

 

 

binuacs
20 - Arcturus

@Srawat can you provide sample input file in excel?

Srawat
8 - Asteroid

Here is the sample file original format in yellow color and blue color format is required and header. Thanks

 

Emmanuel_G
13 - Pulsar

@Srawat 

 

Change the line 7 in input data tool : Start Data import on line 8 as shown below and it wiil work.

 

Emmanuel_G_0-1663938016427.png

 

Felipe_Ribeir0
16 - Nebula

Hi @Srawat 

 

It worked?

Labels