locked
Warning! - JoinKind.RightOuter bug. RRS feed

  • Question

  • Put this code in PQ advanced editor window and see the result of this simple query.

    let
        TblA = #table( type table [A = Int64.Type], {{2},{7},{9},{10}}),
        TblB = #table( type table [B = Int64.Type], {{5},{2},{7}}),
        #"Merged Queries" = Table.NestedJoin(TblA,{"A"},TblB,{"B"},"TblB",JoinKind.RightOuter),
        #"Filtered Rows" = Table.SelectRows(#"Merged Queries", each ([A] = null)),
        #"Expanded {0}" = Table.ExpandTableColumn(#"Filtered Rows", "TblB", {"B"}, {"B"})
    in
        #"Expanded {0}"
    Of course there are some workarounds (it doesn't matter)  but this is definitely a bug.
    Windows 8.1 (x64)
    Excel 2010 (x86)
    PQ ver. 2.51.4885.721 (32bit) 

    Wednesday, January 17, 2018 5:18 PM

Answers