다음을 통해 공유

Transform multiline records into a table

  • 아티클

This post was moved here.

Comments

  • Anonymous
    July 27, 2015
    Very well explained in details. Thanks a lot for sharing this :-)
  • Anonymous
    July 28, 2015
    I did something very similar in analyzing XML version of SQL Server Profiler trace logs:

    let
    Source = Xml.Tables(File.Contents("C:UsersdonpDownloadstrace.xml")),
    Table1 = Source{1}[Table],
    Table = Table1{0}[Table],
    #"Changed Type" = Table.TransformColumnTypes(Table,{{"Attribute:id", Int64.Type}, {"Attribute:name", type text}}),
    #"Filtered Rows" = Table.SelectRows(#"Changed Type", each ([#"Attribute:name"] = "Query End")),
    #"Added Index" = Table.AddIndexColumn(#"Filtered Rows", "Index", 0, 1),
    #"Removed Columns" = Table.RemoveColumns(#"Added Index",{"Attribute:id", "Attribute:name"}),
    #"Reordered Columns" = Table.ReorderColumns(#"Removed Columns",{"Index", "Column"}),
    #"Expand Column" = Table.ExpandTableColumn(#"Reordered Columns", "Column", {"Attribute:name", "Element:Text"}, {"Attribute:name", "Element:Text"}),
    #"Pivoted Column" = Table.Pivot(#"Expand Column", List.Distinct(#"Expand Column"[#"Attribute:name"]), "Attribute:name", "Element:Text"),
    in
    #"Pivoted Column"
  • Anonymous
    July 30, 2015
    Excel for Security Analysts is a series of blog posts for Security, Data and BI analysts. In this series
  • Anonymous
    August 04, 2015
    Excel for Security Analysts
  • Anonymous
    November 09, 2015
    ah some sort of super transpose?
  • Anonymous
    November 09, 2015
    Super transpose - I like this name :)
  • Anonymous
    January 25, 2016
    The comment has been removed