Curious to see how others approach this and for something so simple i had to resort to SQL instead of using the query editor (i have a strong feeling this is going to be user error). Even a quick google did not produce any straight froward answers which again for something so simple seems strange.
Table A, B and C all have multiple different columns in a different format.
I would like to take:
• Column 1 from table A
• Column 5 from table B
• Column 7 from table C
Append does not appear to work as all are a different format and does not combine into one column.
How would others approach this scenario?