How to create a table from two tables by not merging queries

[Vis26]

Hello, so I have two tables, one table with the original data  that I grabbed from db and the other where I created a new table in Bi using the original data but adjusted the date to show 6 months ahead and ID has a "-ND" at the end to identify the new date. I wanted to combine these two tables to create one table so I can have both datasets in a single visualization. Any help would be appreciated, thank you!

Table 1

ID	Date	Bonus
1	1/1/2024	$100
2	3/1/2024	$200

Table 2 

ID	Date	Bonus
1-ND	7/1/2024	$100
2-ND	9/1/2024	$200

Combined Data

ID	Date	Bonus
1	1/1/2024	$100
2	3/1/2024	$200
1-ND	7/1/2024	$100
2-ND	9/1/2024	$200

[barritown · Accepted solution]

Hello @Vis26,

I guess you will have to create a new table via Table Tools -> New Table and UNIONize the tables you have. 

Best Regards,

Alexander

My YouTube vlog in English

My YouTube vlog in Russian