Hi,
Could you please let me how I can pick the yellow highlighted row as a header row in alteryx.
Thanks,
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
Hey @Srawat,
Choose the desired line in the input Tool.
Hi @Srawat
Find attached the way of doing that.
It is working fine however unable to get correct header please refer filter and then dynamic tool and advise. Thanks.
@Srawat can you provide sample input file in excel?
Here is the sample file original format in yellow color and blue color format is required and header. Thanks
It worked?
