Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Just do that code and see both 1 and 2 steps.
In step 1. you can see 2 values in ww Table instead of 1 (which you can see in Source step.
In step 2. you can still see row with null valiues, despite the filter for not null values.
That's a relation - fundamental function for data handling, please fix the bug urgently!
let Source = Table.NestedJoin(Table.Buffer(#table(type table [k = number, w = text], {{1, "w"}, {2, "w"}})), {"k"}, Table.Buffer(#table(type table [k = number, w = text], {{2, "k"}, {4, "w"}})), {"k"}, "ww", JoinKind.FullOuter), #"1.Zombie Values if filter Null" = Table.SelectRows(Source, each ([w] = null)), #"2.Zombie Null Rows when filter not null" = Table.SelectRows(Source, each ([w] <> null)) in #"2.Zombie Null Rows when filter not null"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.