Forum Discussion

Frequent Visitor

5 years ago

Converting XML.Tables into usable expandable columns

Hey, I've got some XML with computer data inside it created along similar lines to this article: Creating Custom XML from .NET and PowerShell Hardware: https://pastebin.com/ca1rxYuu Network...

Tutorial Requests

lbendlin

Super User

5 years ago

Something like this?

let
    Source = Xml.Tables(File.Contents("C:\Users\xxx\Downloads\computer.xml")),
    Object = Source{0}[Object],
    #"Expanded Property" = Table.ExpandTableColumn(Object, "Property", {"Element:Text", "Attribute:Name"}, {"Element:Text", "Attribute:Name.1"}),
    #"Added Custom" = Table.AddColumn(#"Expanded Property", "Attribute", each [#"Attribute:Name"] & ":" & [#"Attribute:Name.1"]),
    #"Reordered Columns" = Table.ReorderColumns(#"Added Custom",{"Attribute", "Element:Text", "Attribute:Name.1", "Attribute:Name"}),
    #"Renamed Columns" = Table.RenameColumns(#"Reordered Columns",{{"Element:Text", "Value"}}),
    #"Removed Other Columns" = Table.SelectColumns(#"Renamed Columns",{"Attribute", "Value"})
in
    #"Removed Other Columns"