Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.