Skip to content

Instantly share code, notes, and snippets.

@CurtHagenlocher

CurtHagenlocher/FilterByValues.m

Created May 14, 2015 21:00
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save CurtHagenlocher/ae1cbf55b2a7e138a37c to your computer and use it in GitHub Desktop.
Save CurtHagenlocher/ae1cbf55b2a7e138a37c to your computer and use it in GitHub Desktop.
Download ZIP
Filter by values from another table
Raw
FilterByValues.m
let
data = Table.FromColumns({{1, 2, 3, 4, 5}, {"Left", "Right", "Center", "Left", "Right"}}),
filter = Table.FromColumns({{"Right", "Center"}}),
filterValues = filter[Column1],
filtered = Table.SelectRows(data, each List.Contains(filterValues, [Column2]))
in
filtered
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment