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.
XML input stage - XML Parshing job aborts if tags missing
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 39
- Joined: Tue Feb 28, 2012 12:59 pm
- Location: Chennai
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
Ernie
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
-
- Participant
- Posts: 246
- Joined: Mon Jun 30, 2008 3:22 am
- Location: New York
- Contact: