Skip to content

Instantly share code, notes, and snippets.

@HansPeterPfister

HansPeterPfister/join_case_insensitive.M

Last active May 11, 2018 18:55
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 HansPeterPfister/5e1516da97c8e7b2f3e0b34fb6a7fbf5 to your computer and use it in GitHub Desktop.
Save HansPeterPfister/5e1516da97c8e7b2f3e0b34fb6a7fbf5 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
join_case_insensitive.M
let
Quelle = Table.AddColumn(Trans, "Merge",
(case_insensitive) => Table.SelectRows(Dept,
each Text.Upper([Name]) = Text.Upper(case_insensitive[Name]))),
#"Expanded Merge" = Table.ExpandTableColumn(Quelle, "Merge", {"Name", "Dept"}, {"Emp.Name", "Emp.Dept"})
in
#"Expanded Merge"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment