für stat_1hz
let
Quelle = Json.Document(Web.Contents("https://apiv3.apifootball.com/?action=get_events&match_live=1&APIkey=e9f94294d552903ddc450983c69ce4e20f9737c3789bed7ac12684fe748acdd9")),
#"In Tabelle konvertiert" = Table.FromList(Quelle, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Erweiterte Column1" = Table.ExpandRecordColumn(#"In Tabelle konvertiert", "Column1", {"match_id", "statistics_1half"}, {"match_id", "statistics_1half"}),
#"Erweiterte statistics_1half" = Table.ExpandListColumn(#"Erweiterte Column1", "statistics_1half"),
#"Erweiterte statistics_1half1" = Table.ExpandRecordColumn(#"Erweiterte statistics_1half", "statistics_1half", {"type", "home", "away"}, {"type", "home", "away"}),
#"Umbenannte Spalten" = Table.RenameColumns(#"Erweiterte statistics_1half1",{{"match_id", "match_id3"}, {"type", "type3"}, {"home", "home3"}, {"away", "away3"}}),
#"Entfernte Spalten" = Table.RemoveColumns(#"Umbenannte Spalten",{"match_id3"}),
#"Gefilterte Zeilen" = Table.SelectRows(#"Entfernte Spalten", each ([type3] null)),
#"Tiefer gestufte Header" = Table.DemoteHeaders(#"Gefilterte Zeilen"),
#"Geänderter Typ" = Table.TransformColumnTypes(#"Tiefer gestufte Header",{{"Column1", type text}, {"Column2", type text}, {"Column3", type text}}),
#"Transponierte Tabelle" = Table.Transpose(#"Geänderter Typ"),
#"Höher gestufte Header" = Table.PromoteHeaders(#"Transponierte Tabelle", [PromoteAllScalars=true]),
#"Geänderter Typ1" = Table.TransformColumnTypes(#"Höher gestufte Header",{{"type3", type text}, {"Throw In", Int64.Type}, {"Free Kick", Int64.Type}, {"Goal Kick", Int64.Type}, {"Penalty", Int64.Type}, {"Substitution", Int64.Type}, {"Attacks", Int64.Type}, {"Dangerous Attacks", Int64.Type}, {"On Target", Int64.Type}, {"Off Target", Int64.Type}, {"Throw In_1", Int64.Type}, {"Free Kick_2", Int64.Type}, {"Goal Kick_3", Int64.Type}, {"Penalty_4", Int64.Type}, {"Substitution_5", Int64.Type}, {"Attacks_6", type any}, {"Dangerous Attacks_7", type any}, {"On Target_8", type any}, {"Off Target_9", type any}, {"Throw In_10", Int64.Type}, {"Free Kick_11", Int64.Type}, {"Goal Kick_12", Int64.Type}, {"Penalty_13", Int64.Type}, {"Substitution_14", Int64.Type}, {"Attacks_15", Int64.Type}, {"Dangerous Attacks_16", Int64.Type}, {"On Target_17", Int64.Type}, {"Off Target_18", Int64.Type}, {"Throw In_19", Int64.Type}, {"Free Kick_20", Int64.Type}, {"Goal Kick_21", Int64.Type}, {"Penalty_22", Int64.Type}, {"Substitution_23", Int64.Type}, {"Attacks_24", Int64.Type}, {"Dangerous Attacks_25", Int64.Type}, {"On Target_26", Int64.Type}, {"Off Target_27", Int64.Type}, {"Throw In_28", Int64.Type}, {"Free Kick_29", Int64.Type}, {"Goal Kick_30", Int64.Type}, {"Penalty_31", Int64.Type}, {"Substitution_32", Int64.Type}, {"Attacks_33", Int64.Type}, {"Dangerous Attacks_34", Int64.Type}, {"On Target_35", Int64.Type}, {"Off Target_36", Int64.Type}, {"Shots Total", Int64.Type}, {"Shots On Goal", Int64.Type}, {"Shots Off Goal", Int64.Type}, {"Shots Blocked", type any}, {"Shots Inside Box", type any}, {"Fouls", Int64.Type}, {"Corners", Int64.Type}, {"Offsides", Int64.Type}, {"Yellow Cards", Int64.Type}, {"Red Cards", Int64.Type}, {"Saves", Int64.Type}, {"Throw In_37", Int64.Type}, {"Free Kick_38", Int64.Type}, {"Goal Kick_39", Int64.Type}, {"Penalty_40", Int64.Type}, {"Substitution_41", Int64.Type}, {"Attacks_42", Int64.Type}, {"Dangerous Attacks_43", Int64.Type}, {"On Target_44", Int64.Type}, {"Off Target_45", Int64.Type}, {"Throw In_46", Int64.Type}, {"Free Kick_47", Int64.Type}, {"Goal Kick_48", Int64.Type}, {"Penalty_49", Int64.Type}, {"Substitution_50", Int64.Type}, {"Attacks_51", Int64.Type}, {"Dangerous Attacks_52", Int64.Type}, {"On Target_53", Int64.Type}, {"Off Target_54", Int64.Type}, {"Throw In_55", Int64.Type}, {"Free Kick_56", Int64.Type}, {"Goal Kick_57", Int64.Type}, {"Penalty_58", Int64.Type}, {"Substitution_59", Int64.Type}, {"Attacks_60", Int64.Type}, {"Dangerous Attacks_61", Int64.Type}, {"On Target_62", Int64.Type}, {"Off Target_63", Int64.Type}})
in
#"Geänderter Typ1"