Forum Discussion
Union column order
I'm trying to use the UNION function with two summarized tables and a third table. The first two tables are summarized in the exact same way, and their resulting column order is also the same. Th...
I tried this, but similar to using SELECTCOLUMNS, the calculated column still wants to become the first column.
Interesting!
I tried my solution before posting and had no difficulty creating a desired column order.
Tom
I wish we could UNION on something less arbirary than column order. I believe APPEND in query editor uses column names.\
*edit* Unfortunately, I can't use append or model my data in the query editor. I had to use UNION to join my source data which is separated by month. I don't need the past months' data to refresh. If I were to APPEND those tables, even if they were flagged not to refresh they would refresh.