topic Re: xml file in Talend Studio

xml file

lmit — Thu, 25 Jul 2019 11:06:15 GMT

Hi All,

I have a requirement where i need to process the xml file and am processing xml file first time,i tried configuring with the help got in the community and documnets but not able to read it properly so can you please help in configuring the xml.please find the attachment the sample xml file
thanks,
Lmit

Re: xml file

lmit — Fri, 26 Jul 2019 13:36:28 GMT

Hi All,

Any help on the below would be helpful.

Thanks in advance,

lmit

Re: xml file

lmit — Mon, 29 Jul 2019 07:32:54 GMT

Hi all,

I tried all the ways to process the attached XML but failed

Any help would be really helpful

Thanks in advance,
Lmit

Re: xml file

manodwhb — Fri, 09 Aug 2019 12:51:00 GMT

@lmit ,what was the problem and share the way and what error are you getting?

Re: xml file

lmit — Fri, 20 Sep 2019 07:26:24 GMT

Hi Manohar,

I have a sample xml file whcih is the structure of my output file . so i was trying to read the the xml.

evenafter giving the tag in the mapper am not getting the schema whcich is matching the sample file. few feilds are missing.

attaching xml & xsd file . can you tell the actually process of creating the xml file. i have followed the talend componenet documents but couldnot successed.

nothing specific error , not able to read correctly.

Thanks in Advance,

lmit

examplefile.xml

Re: xml file

manodwhb — Fri, 20 Sep 2019 07:42:16 GMT

@lmit ,please check from the below output is got what ever you required.

output:-

Re: xml file

lmit — Mon, 23 Sep 2019 07:42:21 GMT

Thanks Manohar for your quick reply

i have send different xml file. few difference are there in the files. sorry about that.

I followed your screenshoots and tried to recreate the same. but when i gave first name & birth date after Denomination . these 2 columns are not coming one after the other.

Can you please show the mappping & schema for the new file whcih am attaching.

Thanks in advance,

lmit

sample.xml

Re: xml file

lmit — Mon, 23 Sep 2019 08:16:25 GMT

Hi Manohar,

Please find the attachment for the mapping which i created. data is coming a one column.

Please suggest where am doing wrong.

Thansk in advance,

lmit

xml_mapping.PNG

Re: xml file

manodwhb — Mon, 23 Sep 2019 09:55:30 GMT

@lmit ,if your using the same sample file which you shared with me than the problem would be Xpath query.

Re: xml file

lmit — Mon, 23 Sep 2019 10:12:33 GMT

I used the file which i shared today.attraching here also

the screenshot which you shared with example.xml is little different to the one i shared today and the mapping i have shared today

Thanks,

lmit

sample.xml

Re: xml file

manodwhb — Mon, 23 Sep 2019 10:27:43 GMT

@lmit ,with below xpath query, i am able to extract the data,please check the below screen.

Re: xml file

lmit — Mon, 23 Sep 2019 11:34:49 GMT

Thanks manohar now am able to read it.

Once again thanks

thanks,

lmit

Re: xml file

manodwhb — Mon, 23 Sep 2019 11:36:57 GMT

@lmit ,Please accept the solution.