Pq merge

[sadath]

Hi,
Assume I have two table to merge in power qurty

SL Value
1 350
2 6545
4 64
6 654
7 464

SL Value
2 170
3 64
5 46
8 64

I tried FullOuter(All rows from both) result is
SL Value Sum of Value
1 350
2 6545 170
4 64
6 654
7 464
174

I need
SL Value Value1
1 350
2 6545 170
3 64
4 64
5 46
6 654
7 464
8 64

which merge should i use?

 

[VBA Geek]

try something like this:

let
    Table1 = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    Table2 = Excel.CurrentWorkbook(){[Name="Table2"]}[Content],


    CombineTables = Table.Combine({Table1,Table2}),


    Grp = Table.Group(
                        CombineTables,
                        {"SL"},
                        {{"Values", each Text.Combine(List.Transform(_[Value], Text.From), ","), type text}},
                        GroupKind.Global
                    ),


    SplitColumnbyDelimiter = Table.SplitColumn( Grp, 
                                                "Values", 
                                                Splitter.SplitTextByDelimiter(","), 
                                                {"Values1", "Values2"}
                                             )
in
    SplitColumnbyDelimiter