topic Re: tExtractXMLField and empty node in the xml file in Talend Studio

tExtractXMLField and empty node in the xml file

Anonymous — Mon, 24 Jul 2017 11:18:53 GMT

Hello

I'm working on a talend job that has been developed in the past and that is working correctlfy so i can't change all in this job. i have to add some fields from an xml file and some node where i need to take thoses fields can be empty...
exemple i can have on my xml file this :
<CarBookings/>
<MiscellaneousBookings/>

or they can be filled :

....

<component_id>xxxxx</component_id>

</CarBookings>

to extract node of the files, the job is using tExtractXMLFields for each node needed ...

So i add one for each of the node i need but as soon as 1 node is empty, i'm loosing all the previous data extracted from the previous tExtractXMLFields.

how i can do differently ?

Many thanks for your help !

Re: tExtractXMLField and empty node in the xml file

Anonymous — Mon, 24 Jul 2017 20:38:41 GMT

Can you provide screenshots of your jobs and when it is losing all the other values?

Re: tExtractXMLField and empty node in the xml file

Anonymous — Tue, 25 Jul 2017 09:01:42 GMT

Hello

Thanks for your answer.
Here a screenshot of this part of the job

i have just add on this the tExtractXMLField who is not aligned with the others and i'm loosign all my datas because the tags activity_booking on this xml file is empty.

The xPath on the new tExtractXMLField is : "ActivityBookings/ActivityBooking/"

and i add a column in the schema Component_id2 : "ComponentInfo/ComponentID"

Capture.PNG

Re: tExtractXMLField and empty node in the xml file

Anonymous — Fri, 08 Sep 2017 10:51:14 GMT

I am facing similar issue in my project.

I am calling webservices and successfully getting the output. however the format in browser is different.

So tried to extract it using tExtractXmlField. I am getting value for StateProvince "AA" but StreetName is null.

I tried using different loopxpath in second loop just to get StreetName value.

Is there any way to get output in same format as it is displaying in browser.

Please let me know.

Also I tried to create a new discussion for this but not sure how.

tExtractXmlField_configuration.png
output_of_tExtractXmlField.png
output_from_webservices_in_talend.png
webservice_output_in_browser.png
s1.png