Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
hay_y
Contributor II
Contributor II

Handling NULL or Empty XML in tXMLMap

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. 

hay_y_0-1717614485365.png

 

Screenshot 2024-06-05 150209.png

 

hay_y_2-1717614553539.png

 

Screenshot 2024-06-05 150313.png

 

 

Labels (5)
1 Solution

Accepted Solutions
Shicong_Hong
Support
Support

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.

Shicong_Hong_0-1718283504197.png

 

Regards

Shicong

 

View solution in original post

3 Replies
Shicong_Hong
Support
Support

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.

Shicong_Hong_0-1718283504197.png

 

Regards

Shicong

 

hay_y
Contributor II
Contributor II
Author

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

hay_y
Contributor II
Contributor II
Author

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 

hay_y_0-1718295730636.png

 

hay_y_1-1718295761150.png

 

hay_y_2-1718295800197.png