Created
May 13, 2024 08:38
-
-
Save hansgafriedzal/3c32f2ac9e41f5894e8dc238551b8a41 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
= (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