XML input stage - XML Parshing job aborts if tags missing

techiexavier · Post by **techiexavier** » Thu Sep 12, 2013 11:51 pm

Hi All,

My job design is as below.

External source(List of file names received) --> XML input(URL option) --> Dataset.

In XML input stage we have transformations as below,

/Top/Cust:Customer/Cust:Flag/text()

This transformation works fine when the input files proper. But in some cases in the source XML file, the tag for filed "Flag" itself will not be given if the data is not available from the source. Due to this my job getting aborted.

Is there any way to have Null to be populated when tag is missing or is there any other way to get this done.

TIA.

eostic · Post by **eostic** » Fri Sep 13, 2013 5:05 am

I've never seen a job abort for this reason alone.....you should get nulls for that column, or if it is the repating element (marked as key) then you will not get a row for that node.......are there other elements present for that node?

Ernie

arunkumarmm · Post by **arunkumarmm** » Fri Sep 13, 2013 8:39 am

What is the error message you get when your job aborts?