I am quiet new to Jet Enterprise, but not new to BI, and i was wondering if there is a way (other than creating a view on staging) to combine one or more source table into one Destination something like Union (not Union all).
table A: has the data (One, Two, Three)
Table B: Has the data (Three, Four, Five)
as a result i would like to have only
Table DW (One, Two, Three, Four, Five)…
three must not be repeated.
i created a view and solved my prloblem but as mentioned above, just checking if there is another way.
Combine two or more tables into one