DSXchange

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.

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

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