Just pushing this to the top, hopefully someone can help me out.
Hi Noor, you are looking to UNION two data sources of different data types.
The only way to accomplish this task currently is through a third-party data prep tool.
While 9.3 supports UNIONs between like Excel and other like flat files, it is not currently a functionality of the product to UNION two tables from different databases.
A couple of possible options to resolve this issue:
1. use a data prep tool such as Alteryx to create the file that you are looking for
2. Export your GA data into a common filetype such as CSV to properly UNION the information together.
I wonder if anyone else in the community has ideas?
Thanks for your reply Nicholas! Too bad the union isn't supported yet for now. Looking forward to that update in the future and I will try your other suggestions.