Renaming field by position

[PranavGupta]

Hi, is there any way to rename a field name by its position, irrespective of the current field name?

I have to stack multiple files, where the column heading for the 2nd field is not consistent. I want to rename the 2nd column, such that, when I run the macro, it renames 2nd column irrespective of the existing field name (column name) in each file.

Please suggest a solution.

Thanks

[JosephSerpis · Accepted solution]

Hi @PranavGupta I came up with a few approaches to tackle this. I've attached my workflow let me know what you think?

[PranavGupta]

Thank you so much Joseph! That works well for me 👍 😊