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?
Solved! Go to Solution.
Join and Union tools can be configured to consider the position and not name.
I am aware of this. I am talking about when it first is imported in before a join or union tool is used.
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.
I just remembered that you can also skip the row using the other config option as well rather than using a select records tool.