let
  Source = AzureStorage.Blobs("https://storagenohierarchy.blob.core.windows.net/eventlogfiles"),
  #"Filtered hidden files" = Table.SelectRows(Source, each [Attributes]?[Hidden]? <> true),
  #"Invoke custom function" = Table.AddColumn(#"Filtered hidden files", "Transform file", each #"Transform file"([Content])),
  #"Renamed columns" = Table.RenameColumns(#"Invoke custom function", {{"Name", "Source.Name"}}),
  #"Removed other columns" = Table.SelectColumns(#"Renamed columns", {"Source.Name", "Transform file"}),
  #"Expanded table column" = Table.ExpandTableColumn(#"Removed other columns", "Transform file", Table.ColumnNames(#"Transform file"(#"Sample file"))),
  #"Changed column type" = Table.TransformColumnTypes(#"Expanded table column", {{"Source.Name", type text}, {"Column1", type text}}),
  #"Split column by delimiter" = Table.SplitColumn(#"Changed column type", "Column1", Splitter.SplitTextByDelimiter(",", QuoteStyle.Csv), {"Column1.1", "Column1.2", "Column1.3", "Column1.4", "Column1.5", "Column1.6", "Column1.7"}),
  #"Changed column type 1" = Table.TransformColumnTypes(#"Split column by delimiter", {{"Column1.1", type text}, {"Column1.2", type text}, {"Column1.3", type text}, {"Column1.4", type text}, {"Column1.5", type text}, {"Column1.6", type text}, {"Column1.7", type text}}),
  #"Filtered rows" = Table.SelectRows(#"Changed column type 1", each [Column1.1] = "id" or [Column1.1] = "info" or [Column1.1] = "play"),
  #"Inserted conditional column" = Table.AddColumn(#"Filtered rows", "VistorTeam", each if [Column1.2] = "visteam" then [Column1.3] else null),
  #"Inserted conditional column 1" = Table.AddColumn(#"Inserted conditional column", "HomeTeam", each if [Column1.2] = "hometeam" then [Column1.3] else null),
  #"Inserted conditional column 4" = Table.AddColumn(#"Inserted conditional column 1", "Ballpark", each if [Column1.2] = "site" then [Column1.3] else null),
  #"Filled down" = Table.FillDown(#"Inserted conditional column 4", {"VistorTeam", "HomeTeam", "Ballpark"}),
  #"Inserted conditional column 2" = Table.AddColumn(#"Filled down", "Date", each if [Column1.2] = "date" then [Column1.3] else null),
  #"Changed column type 2" = Table.TransformColumnTypes(#"Inserted conditional column 2", {{"Date", type date}}),
  #"Filled down 1" = Table.FillDown(#"Changed column type 2", {"Date"}),
  #"Filtered rows 1" = Table.SelectRows(#"Filled down 1", each [Column1.1] = "play"),
  #"Renamed columns 1" = Table.RenameColumns(#"Filtered rows 1", {{"Column1.4", "Player"}, {"Column1.5", "PitchCount"}, {"Column1.6", "PitchSequence"}, {"Column1.2", "Inning"}}),
  #"Removed columns" = Table.RemoveColumns(#"Renamed columns 1", {"Column1.1"}),
  #"Renamed columns 2" = Table.RenameColumns(#"Removed columns", {{"Column1.3", "Home/Visitor"}, {"Column1.7", "Outcome"}}),
  #"Replaced value" = Table.ReplaceValue(#"Renamed columns 2", ".txt", "", Replacer.ReplaceText, {"Source.Name"}),
  #"Changed column type 3" = Table.TransformColumnTypes(#"Replaced value", {{"HomeTeam", type text}, {"VistorTeam", type text}}),
  #"Split column by position" = Table.SplitColumn(#"Changed column type 3", "Source.Name", Splitter.SplitTextByRepeatedLengths(4), {"Source.Name.1", "Source.Name.2"}),
  #"Changed column type 4" = Table.TransformColumnTypes(#"Split column by position", {{"Source.Name.1", Int64.Type}, {"Source.Name.2", type text}}),
  #"Added index" = Table.AddIndexColumn(#"Changed column type 4", "Index", 1, 1, Int64.Type),
  #"Renamed columns 3" = Table.RenameColumns(#"Added index", {{"Index", "ID"}}),
  #"Reordered columns" = Table.ReorderColumns(#"Renamed columns 3", {"ID", "Source.Name.1", "Source.Name.2", "Inning", "Home/Visitor", "Player", "PitchCount", "PitchSequence", "Outcome", "VistorTeam", "HomeTeam", "Date"}),
  #"Inserted conditional column 3" = Table.AddColumn(#"Reordered columns", "IsHomeRecord", each if [Source.Name.2] = [HomeTeam] then 1 else null),
  #"Filtered rows 2" = Table.SelectRows(#"Inserted conditional column 3", each [IsHomeRecord] <> null and [IsHomeRecord] <> ""),
  #"Removed columns 1" = Table.RemoveColumns(#"Filtered rows 2", {"IsHomeRecord"}),
  #"Added custom" = Table.AddColumn(#"Removed columns 1", "Count", each Text.Start([PitchCount],1)&"-"&Text.End([PitchCount],1)),
  #"Removed columns 2" = Table.RemoveColumns(#"Added custom", {"PitchCount"}),
  #"Changed column type 5" = Table.TransformColumnTypes(#"Removed columns 2", {{"Count", type text}}),
  #"Transform columns" = Table.TransformColumnTypes(#"Changed column type 5", {{"Ballpark", type text}}),
  #"Replace errors" = Table.ReplaceErrorValues(#"Transform columns", {{"Ballpark", null}})
in
  #"Replace errors"