topic Re: Handling NULL or Empty XML in tXMLMap in Talend Studio

Handling NULL or Empty XML in tXMLMap

hay_y — Wed, 05 Jun 2024 20:38:25 GMT

I have a job designed to extracts values from XML file using tXMLMap. Pipeline fails when it tries to extract value from XML with no values in it.
I want the pipeline to continue processing other XML and skip empty XML files.

Re: Handling NULL or Empty XML in tXMLMap

Shicong_Hong — Thu, 13 Jun 2024 12:59:18 GMT

Hello

Move the part of job as seen below to a child job, use a tRunJob to call this child job, pass the current file path to child job and uncheck the 'Die on error' option on tRunJob, the main job will continue to process next file even though the child job fails.

Regards

Shicong

Re: Handling NULL or Empty XML in tXMLMap

hay_y — Thu, 13 Jun 2024 13:34:07 GMT

@Shicong_Hong What do you mean move to child job? Could you clarify more?

Re: Handling NULL or Empty XML in tXMLMap

hay_y — Thu, 13 Jun 2024 16:24:25 GMT

After some research, i was able to create the child job and i created optional loop in the tXMLMap with configuring source loops as the picture below. Thanks @Shicong_Hong