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.
I need to ingest a spreadsheet into a database but first change the column names to match the column names from a table that already exists in the database (last years data). I need to do this for a number of tables so can't do it manually.
My thinking was to input the spreadsheet and the table, union the two, select the headers from the table and the data from the spreadsheet, then create a table using the output tool. However I cannot figure out a workflow for this to work, does anyone have any ideas?