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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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?