Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Summarized ColumnTable adding a Column to this table from another Summarised Table.

Good Afternoon,

 

I Have Table 1 which is a summarised version of a larger fact table..  Has Year, Fin Month, Various Columns and a Value.

 

I Have a 2nd Table, which too is a summarised table of a larger fact table.  Also Has Year, Fin Month and 1 Value.

 

I would like to Add Table2's Value Column, to Table 1.

 

First Table
Fin YearFin MonthColumn 1Value
20221Uk200
20221Us300
20221Eur100
20222UK400
20223UK250
Second Table
Fin YearFin MonthValue
2022130000
2022240000
2022350000

 

 

End result required

New Table
Fin YearFin MonthColumn 1Value2nd table Value
20221Uk20030000
20221Us30030000
20221Eur10030000
20222UK40040000
20223UK25050000

 

 

I will be Combining Year and Fin Month to get a singular ID Field  to get a relationship... Just Cannot seem to get the required Output...

 

Any help will be most appreciated.

 

Regards Mike.

 

 

 

 

 

1 Reply