Using UNION to create new table

[rpinxt]

We have a lot of data in a table and wanted to split it in 2 part.

Because all the old data will not change anyway so we decided to put 2 years in a separate excel sheet with exactly the same layout as the original one.

First I did a append to combine the latest year data with the history data.

That works fine however Append will always refresh the historic data apparantly, also when you switch of load on refresh.

So looking around I found you could use UNION to combine the historic data with the new data.

Load in the historic file once and then switch of the refresh for that table.

What I now run into is the fact that UNION has changed the format of my columns!

My amount/value columns all changed to text.....

Why is it doing that and how can I tell it to use the original column formatting of the sources?

[Greg_Deckler]

@rpinxt You can just switch the data types on the created calculated table. Not sure why it would be switching them to text, I can't recreate that behavior. See attached.

[rpinxt · Accepted solution]

@Greg_Deckler yeah must be something strange. Started from scratch with just the 2 excels and doing a union.

Of course nothing strange there.....union is fine, amounts are amounts, dates are dates...

Must be all the other stuff that already has been going on in the existing file.

Also manually changing the fields back resulted time on time for new problems somewhere else.

Think it is better to just start clean and rebuild what I already had. Not that big of  problem as I already have the example from all the visuals.