Updating Column headers regardless of how they are initially named.

[NRD]

I want to use certain columns for my import every time, but I do not  care what they are named so long as they are in that same column location.

When I run the workflow it errors because the name of the fields do not match. Is their a tool that I can use that will not take into consideration the name of the column and will just look at the location?

[AbhilashR]

Join and Union tools can be configured to consider the position and not name.

[NRD]

I am aware of this. I am talking about when it first is imported in before a join or union tool is used.

[BrandonB · Accepted solution]

You can uncheck the box for "first row contains field names" so it will put field 1, field 2, etc as your headers. Then add a select records tool and configure it to pull in 2+ which will skip that first row which now contains your original headers. The resulting data set will standardize field headers. 

  

[BrandonB]

I just remembered that you can also skip the row using the other config option as well rather than using a select records tool.