Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
mahesh_Dev
Contributor III
Contributor III

Xml to Structure Format

Hi,

case1:

I have 23 xml files which is different schema.

in one file the parent and child are more 

<parent>

       <child>

     a= "hello"

                   b= "zhxvctdv"

                   c= "35"

       </child>

        <child>

                  a="hi"

                  b="jfhffggd"

                   c="66"

        </child>

<child>

                  a="me"

                  b="ybhcccc"

                   c="26"

        </child>

</parent>

 

in the above xml data they are two child data

 

i need like this

a           b             c  

hello   zhxvctdv   35

hi         jfhffggd    66

me      ybhcccc    26

 

 

But i have taken the schema everything but i am not getting the values properly?

only one row it is showing

could you help me 

 

Labels (4)
2 Replies
Aukema
Creator
Creator

Can you add some screenshots of the job? First thought: is your loop on the child?

fdenis
Master
Master

you have to add xml loop to child level
then you have to split by "/n" to get each couple name=value
split by "=" to get the value
does key value are always a then b then c?