Forum Discussion

hgorina's avatar
hgorina
Frequent Visitor
10 years ago
Solved

import (filter) xml nodes by node name

I have multiple XML files witn variety of data stored in them.   i need to create tables based on the node names. The data contained in a different nodes of XML file is quite different   here is ...
Need Help
  • Eric_Zhang's avatar
    Eric_Zhang
    10 years ago

    hgorina

    Not quite sure about your requirement, if you'd like to load the elements table by name but not sequentially(0,1,2 etc), you can try

    let
    Source = Xml.Tables(File.Contents("C:\Users\user1\Desktop\1.XML")),
    Table2 = Source{[Name="User"]}[Table]
in
    Table2

Eric_Zhang's avatar
Eric_Zhang
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

hgorina

Not quite sure about your requirement, if you'd like to load the elements table by name but not sequentially(0,1,2 etc), you can try

let
    Source = Xml.Tables(File.Contents("C:\Users\user1\Desktop\1.XML")),
    Table2 = Source{[Name="User"]}[Table]
in
    Table2

hgorina's avatar
hgorina
Frequent Visitor
10 years ago

thanks!

 

It worked.

 

perhaps I need to clarify the task:

 

in multiple XMLs I am working with, some tables exist in all of them, and some tables exist in just some XMLs. Also, the table sequence order is not the same in some of them. that is why it was omportatn to get them by name

 

many thanks again:)