xml input not replicating the output
Posted: Thu Mar 01, 2007 12:41 am
Hai All,
iam struck while working with xml stages. I will be gratefull if anybody helps me to resolve.
Craig Hulett, as Smeitei is also facing a similar problem i thought Joining in the existing group will be easier for
discussion. I understand that i cannot create a rappot when i come inbetween.
Aim:To change the values of the xml elements.(eg:foster to sanjose)
Design:The design goes as Folder->xmlInput->seqfile->transformer->seqfile->xmloutput.
Description:I created the table definitions using the XML Meta Data Importer. At present neither xsd not xslt were used.
The transformer stage were used to change the values under some conditions. The seq files are for perseverance.
XMLInput/Output:
repetition element required unchecked.
Validate input, enable grammar caching xml checked
column def:id, name, city all are varchar.
replace null..,replace empty.. both are checked
Other options set to default.
My project's xml file is very big. i spotted out the errors in outputfile. To work smartly i created a sample xml that could
produce the same error by having a similar hierarchy. when the repetation element is "city", the i/o are as follows.
input:
<?xml version="1.0" encoding="UTF-8"?>
<customers>
<customer id="5000">
<name>mike</name>
<address><city>redwood</city></address>
<address><city>foster</city></address>
<name>nandy</name>
</customer>
</customers>
output:
<?xml version="1.0" encoding="UTF-8"?>
<customers>
<customer id="5000">
<name>mike</name>
<address><city>redwood</city><city>foster</city></address>
</customer>
</customers>
Inferrence:
1)The redwood and foster cities should come under different parent elements that is "address".
2)The name nandy was missing.
Regards,
Kumudhini.
iam struck while working with xml stages. I will be gratefull if anybody helps me to resolve.
Craig Hulett, as Smeitei is also facing a similar problem i thought Joining in the existing group will be easier for
discussion. I understand that i cannot create a rappot when i come inbetween.
Aim:To change the values of the xml elements.(eg:foster to sanjose)
Design:The design goes as Folder->xmlInput->seqfile->transformer->seqfile->xmloutput.
Description:I created the table definitions using the XML Meta Data Importer. At present neither xsd not xslt were used.
The transformer stage were used to change the values under some conditions. The seq files are for perseverance.
XMLInput/Output:
repetition element required unchecked.
Validate input, enable grammar caching xml checked
column def:id, name, city all are varchar.
replace null..,replace empty.. both are checked
Other options set to default.
My project's xml file is very big. i spotted out the errors in outputfile. To work smartly i created a sample xml that could
produce the same error by having a similar hierarchy. when the repetation element is "city", the i/o are as follows.
input:
<?xml version="1.0" encoding="UTF-8"?>
<customers>
<customer id="5000">
<name>mike</name>
<address><city>redwood</city></address>
<address><city>foster</city></address>
<name>nandy</name>
</customer>
</customers>
output:
<?xml version="1.0" encoding="UTF-8"?>
<customers>
<customer id="5000">
<name>mike</name>
<address><city>redwood</city><city>foster</city></address>
</customer>
</customers>
Inferrence:
1)The redwood and foster cities should come under different parent elements that is "address".
2)The name nandy was missing.
Regards,
Kumudhini.