Unify headers from an input file that have the headers in two rows

Hi Community,

I have some input files with the headers in different rows, you can see an example in the "InputDifferentRowHeaders"

I want to unify them all in the same row so I can use a Dynamic Rename, and not using the Select tool to rename all this empty rows.

A friend told me this can be done with a Formula tool, but I don´t know exactly the code for this one.

You can also find attached the output "OutputDifferentRowHeaders" for the output I would be expecting.

Thanks to y´all

InputDifferentRowHeaders.xlsx

OutputDifferentRowHeaders.xlsx

Best Practices

Accepted answers

grazitti_sapna

Hi @lascurainge, i hope this helps.

Thanks.

Headers-custom.yxzp

DavidP

Something like this?

combine header rows.yxzp

DavidP

Hi @lascurainge, if you change the file extension of my attachment to zip, you can unzip the package. Then open the yxmd file in a text editor and edit the 1st line to reflect your Alteryx version. You’ll then be able to open the workflow in Alteryx. The main thing is to make sure that 1st line contains data is checked in the input data tool.