Merging multiple data tables

Merging multiple data tables

Hello,

I have 2 data tables that I need to merge and present a unique table or report. Problem is that tables don't have the same number of columns, and some column are common to both table. I don't see how I can achieve that.

I thought about using UNION, but I nwiil need empty column for non matching ones.

Example
Table 1: Column A, Column B, Column C, Column D
Table 2 : Column A, Column E, Column F, Column C, Column G, Column H

Column A and C are common in both tables. Column H is unique to table 2.

Expected result:
Merged table : Column A, Column C, Column B, Column D, Column E, Column F, Column G, Column H

How can I achieve this in Analytics ?

NB: Table 1 and Table 2 are updated daily.

Regards,