Unknown element on the output warning

[Nisusmage]

Hi, I am extracting an XML file into a table. I have got the XML file to have one recor, two fields, but still get this warning

Code: Select all

MultiDataConvertXMLDatatest..XML_Input: XSLT Processor: Unknown element on the output. Element Name = "AccountNumberLedgerCode"

I am using a folder stage to an xml stage to the transformer to the table.

the XML fil looks like this

Code: Select all

  <?xml version="1.0" encoding="ISO-8859-1" ?> 
- <ExtractPayment>
-      <Record>
          <OwnerNumber>0155105</OwnerNumber> 
          <AccountNumberLedgerCode>one</AccountNumberLedgerCode> 
        </Record>
  </ExtractPayment>

The real XML a lot more fields and i am getting the warning with quite a few.

ANy ideas?

Thanks[/code]

[chulett]

What do your XPath Expressions look like for your example? And what are your XML Input settings?

[Nisusmage]

Ahha, thanks Craig.
the definitions were looking like this:

Code: Select all

/ExtractPayment/Record/AccountNumberLedgerCode

changed to look like this

Code: Select all

/ExtractPayment/Record/AccountNumberLedgerCode/text()

no more warnings.
Thanks

[Nisusmage]

Ahha, thanks Craig.
the definitions were looking like this:

Code: Select all

/ExtractPayment/Record/AccountNumberLedgerCode

changed to look like this

Code: Select all

/ExtractPayment/Record/AccountNumberLedgerCode/text()

no more warnings.
Thanks

[chulett]

There you go. Time to mark the thread as Resolved, it seems.

[ray.wurlod]

Moderator: please move to server forum