This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
You can use the "first row contains data" in the Input tool. That will push the data down a row and make each column Field 1, Field 2. From there you can do a lot of different things to match the data from using a sample tool to pull the first row out and then changing the names and then Union the correct field name son top of the data and using the Dynamic Rename tool to pull that data into the header.
Remember that if you bring in all of the spreadsheets at once, your headers will be in the data.
You also have the option of creating a batch macro that will bring in data by position and ignore the names of the fields. You can then use the dynamic rename again to update the fields.