I'm sure this is really simple but I can't seem to find the answer online. Many queries are about translating rows to Column Names but I'm specifically after how I can make the column names of my table equal to the ones of another table. I know this is dangerous because it requires the columns to be in the right order and no new columns to appear or old ones to dissapear but I will gladly take that risk on.
Company Date Sales
Bob Co 27/04/2018 20
A B C
Bob Co 27/04/2016 30
I would like Table 2 to inherit Table 1's column names. I can't just hardcode it because the columnames in Table 1 can change.
I've tried the following but got this error: Expression.Error: We expected a RenameOperations value.