Skip to content

Instantly share code, notes, and snippets.

@FthrsAnalytics

FthrsAnalytics/Static Column Merging

Created February 13, 2019 16:39
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 FthrsAnalytics/271c8ffac7028874e650df013d01e687 to your computer and use it in GitHub Desktop.
Save FthrsAnalytics/271c8ffac7028874e650df013d01e687 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Static Column Merging
let
Source = Excel.CurrentWorkbook(){[Name=Table]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Person", type text}, {"City", type text}, {"Index", type text}, {"Percentage", Int64.Type}, {"Application Date", type date}}),
#"Pivoted Column" = Table.Pivot(#"Changed Type", List.Distinct(#"Changed Type"[Index]), "Index", "Percentage", List.Sum),
#"Changed Type1" = Table.TransformColumnTypes(#"Pivoted Column",{{"1", type text}, {"2", type text}, {"3", type text}}),
#"Merged Columns" = Table.CombineColumns(#"Changed Type1", {"1", "2", "3", "4"},Combiner.CombineTextByDelimiter(",", QuoteStyle.None),"Merged"),
#"Trim Text" = Table.AddColumn(#"Merged Columns", "Percentages", each Text.TrimEnd([Merged], ","), type text),
#"Removed Columns" = Table.RemoveColumns(#"Trim Text",{"Merged"})
in
#"Removed Columns"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment