Skip to content

Instantly share code, notes, and snippets.

@hansgafriedzal
Created May 13, 2024 08:38
Show Gist options
  • Save hansgafriedzal/3c32f2ac9e41f5894e8dc238551b8a41 to your computer and use it in GitHub Desktop.
Save hansgafriedzal/3c32f2ac9e41f5894e8dc238551b8a41 to your computer and use it in GitHub Desktop.
= (Path as text) => let
Custom1 = Csv.Document(File.Contents(Path),[Delimiter=",", Columns=17, Encoding=1252, QuoteStyle=QuoteStyle.None]),
#"Promoted Headers" = Table.PromoteHeaders(Custom1, [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"timeStamp", type text}, {"elapsed", Int64.Type}, {"label", type text}, {"responseCode", Int64.Type}, {"responseMessage", type text}, {"threadName", type text}, {"dataType", type text}, {"success", type logical}, {"failureMessage", type text}, {"bytes", Int64.Type}, {"sentBytes", Int64.Type}, {"grpThreads", Int64.Type}, {"allThreads", Int64.Type}, {"URL", type text}, {"Latency", Int64.Type}, {"IdleTime", Int64.Type}, {"Connect", Int64.Type}}),
#"Extracted First Characters" = Table.TransformColumns(#"Changed Type", {{"timeStamp", each Text.Start(_, 10), type text}}),
#"Added Custom" = Table.AddColumn(#"Extracted First Characters", "Custom", each #datetime(1970,1,1,0,0,0) + #duration(0,8,0,Number.From([timeStamp]))),
#"Changed Type 2" = Table.TransformColumnTypes(#"Added Custom",{{"Custom", type datetime}})
in
#"Changed Type 2"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment