Skip to content

Instantly share code, notes, and snippets.

@HansPeterPfister
Last active May 11, 2018 18:55
Show Gist options
  • Save HansPeterPfister/5e1516da97c8e7b2f3e0b34fb6a7fbf5 to your computer and use it in GitHub Desktop.
Save HansPeterPfister/5e1516da97c8e7b2f3e0b34fb6a7fbf5 to your computer and use it in GitHub Desktop.
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