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 am new - of course I am - that is why I ask this question.
I have an issue with combining 2 files together - an example attached.
1 file contains multiple columns that have names and some rows with numbers/text in them
2nd file is a 2 row file. It contains the same names of the columns as the 1st file, plus some more columns with names. Also the second file contains another row - 2nd row are "explanations" for the column names in the 1st row.
The trick is to combine them together in a way to have all the names from the second file, all the explanations from the second file and also - the hardest part for me now - to move the data that is in the 1st file under specific name, to the proper name/column - that will be added/used from the second file.
Well I'm 0-and-1 on recommending Union as an approach tonight but this seems to replicate your output. Depending on the requirements, may be able to use a Dynamic Rename (Developer Tools) if the values from the second file aren't needed in the data. Key thing may be setting the output order in the union.