topic Re: Xml to Structure Format in Talend Studio

Xml to Structure Format

mahesh_Dev — Sat, 16 Nov 2024 07:37:20 GMT

Hi,

case1:

I have 23 xml files which is different schema.

in one file the parent and child are more

<child>

　　　　　ａ= "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

Re: Xml to Structure Format

Aukema — Thu, 20 Sep 2018 10:19:14 GMT

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

Re: Xml to Structure Format

fdenis — Thu, 20 Sep 2018 11:05:05 GMT

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?