Want to pick specific row as a header

[Srawat]

Hi,

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

Thanks,

[Felipe_Ribeir0]

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

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]

Hey  @Srawat, 

Choose the desired line in the input Tool. 

[Emmanuel_G]

Hi @Srawat 

Find attached the way of doing that.

[Srawat]

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

[binu_acs]

@Srawat can you provide sample input file in excel?

[Srawat]

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

[Emmanuel_G]

@Srawat 

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

[Felipe_Ribeir0]

Hi @Srawat 

It worked?