Forum Discussion

jhsimb's avatar
jhsimb
Frequent Visitor
2 years ago

List.Contains() is slow

I tried to filter a column based on a list I used List.Contains() but it is very slow   = Table.SelectRows(Medidas, each (List.Contains(Resta,[Cliente])=true ))   Please your help with a faster ...
Need Help
Show and Tell
slorin's avatar
slorin
Super User
2 years ago

Hi,

use Table.NestedJoin with JoinKind.Inner

 

= Table.NestedJoin(Medidas, {"Cliente"}, Table.FromColumns({Resta},{"Resta"}), {"Resta"}, "JoinColumn", JoinKind.Inner)

then remove column "JoinColumn"

Stéphane