Ignoring XML tags
Posted: Tue Feb 22, 2011 2:26 am
Hello everybody..
I have a job which has a xml file as input that loads data into multiple tables. Now, the file we receive comes with few other tags also which we have to ignore.
eg:
<ns10:myAssetDetails xmlns:ns11="xxxx:xxx-xxxxx:vs.2001-10-01" xmlns:ns14="xxxx:xxx-xxxxx:vs.2001-10-01" xmlns:ns13="xxxx:xxx-xxxxx:asset.2009-04-09" xmlns:ns15="xxxx:xxx-xxxxx:vs.2001-10-01:np.network.2005-02-18">
I have tags simillar to this.. These are repetitive ... Now when i import the metadata i get the below error.
The xml declaration is unexpecte.Line1,Postion 2333. How do i quitely ignore these tags,and the data underlying in it? I do not need these values and i also don't have xsd.
If i run the file with my exixting job i get the below error:
XML_Input_1,0: Warning: xmlload.XML_Input_1: XML input document parsing failed. Reason: Xalan fatal error (publicId: , systemId: /chap/rdr/Data/outputfiles/xmlload.xml, line: 1, column: 2336): No processing instruction starts with 'xml'
Thanks.
I have a job which has a xml file as input that loads data into multiple tables. Now, the file we receive comes with few other tags also which we have to ignore.
eg:
<ns10:myAssetDetails xmlns:ns11="xxxx:xxx-xxxxx:vs.2001-10-01" xmlns:ns14="xxxx:xxx-xxxxx:vs.2001-10-01" xmlns:ns13="xxxx:xxx-xxxxx:asset.2009-04-09" xmlns:ns15="xxxx:xxx-xxxxx:vs.2001-10-01:np.network.2005-02-18">
I have tags simillar to this.. These are repetitive ... Now when i import the metadata i get the below error.
The xml declaration is unexpecte.Line1,Postion 2333. How do i quitely ignore these tags,and the data underlying in it? I do not need these values and i also don't have xsd.
If i run the file with my exixting job i get the below error:
XML_Input_1,0: Warning: xmlload.XML_Input_1: XML input document parsing failed. Reason: Xalan fatal error (publicId: , systemId: /chap/rdr/Data/outputfiles/xmlload.xml, line: 1, column: 2336): No processing instruction starts with 'xml'
Thanks.