Consolidate two tables

Table1 Table2 Result
YEAR VESSEL NR NET CLAIM YEAR UNDERWRITER SHARE VESSEL NR PREMIUM YEAR UNDERWRITER VESSEL Premium Claim
2017
 A
1
0
2017
 X 0,6 A
1
2500
2017
 X A
2500
0
2017
 B
2
2000
2017
 X 0,6 B
2
2750
2017
 Y A
2850
0
2017
 B
2
3000
2017
 X 0,6 C
3
1750
2017
 X B
5500
5000
2017
 C
3
0
2018
 X 0,6 A
1
2900
2017
 Y B
6200
5000
2018
 A
1
1750
2018
 X 0,6 B
2
3150
2017
 X C
1750
0
2018
 B
2
3000
2018
 X 0,6 C
3
2150
2017
 Y C
2100
0
2018
 B
2
4000
2019
 X 0,6 A
1
3500
2018
 X A
2900
1750
2018
 B
2
5000
2019
 X 0,6 B
2
3400
2018
 Y A
3250
1750
2018
 C
3
0
2019
 X 0,6 C
3
4000
2018
 X B
9450
12000
2019
 A
1
0
2017
 Y 0,4 A
1
2850
2018
 Y B
10500
12000
2019
 B
2
5000
2017
 Y 0,4 B
2
3100
2018
 X C
2150
0
2019
 C
3
20000
2017
 Y 0,4 C
3
2100
2018
 Y C
2500
0
2018
 Y 0,4 A
1
3250
2019
 X A
3500
0
2018
 Y 0,4 B
2
3500
2019
 Y A
3850
0
2018
 Y 0,4 C
3
2500
2019
 X B
3400
5000
2019
 Y 0,4 A
1
3850
2019
 Y B
3750
5000
2019
 Y 0,4 B
2
3750
2019
 X C
4000
20000
2019
 Y 0,4 C
3
4350
2019
 Y C
4350
20000


Code:
let
    Tbl1 = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    Tbl2 = Excel.CurrentWorkbook(){[Name="Table2"]}[Content],
    Merge = Table.NestedJoin(Tbl1,{"YEAR", "VESSEL", "NR"},Tbl2,{"YEAR", "VESSEL", "NR"},"Tbl2",JoinKind.LeftOuter),
    Expand = Table.ExpandTableColumn(Merge, "Tbl2", {"UNDERWRITER", "SHARE", "PREMIUM"}, {"UNDERWRITER", "SHARE", "PREMIUM"}),
    TSC = Table.SelectColumns(Expand,{"YEAR", "UNDERWRITER", "VESSEL", "PREMIUM", "NET CLAIM"}),
    Group = Table.Group(TSC, {"YEAR", "UNDERWRITER", "VESSEL"}, {{"Premium", each List.Sum([PREMIUM]), type number}, {"Claim", each List.Sum([NET CLAIM]), type number}}),
    Sort = Table.Sort(Group,{{"YEAR", Order.Ascending}, {"VESSEL", Order.Ascending}, {"UNDERWRITER", Order.Ascending}})
in
    Sort