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,