xpath Metadata Importer Stage

sanjay · Post by **sanjay** » Tue Jan 29, 2008 4:50 pm

Hi All

has a query regardaing xpath

can we set xpath

party id =

GWML//parties/*[@id=../../..//borrowerPartyReference/@idref]/partyId/alt[@domain="GWML/partyId/2.0"]

in Metadata Importer Stage

because when i use xmlspy it returns party id value for above xpath
it is like a nested xpath

Thanks
Sanjay

JoshGeorge · Post by **JoshGeorge** » Wed Feb 06, 2008 4:49 am

You can use Nested XPath Expression in XML stage.

eostic · Post by **eostic** » Wed Feb 06, 2008 10:25 pm

It should work fine, but be sure to test it well. ...and be aware of whatever behavior it might have if an element in the path is missing (not in the current node or anywhere in the document) etc. Such behavior is predictable in the Stage when doing standard retrieval, and there are settings to customize it....but this could complicate things.

The customized logic is great, and sometimes allows for some wonderful techniques, but be aware of the fact that it is in the Description attribute of a column link, so is not particularly easy to edit/search/find & replace, etc. ...nor is it a place where DataStage users maintaining your job in the future may think of to look for specific selection details --- so use annotations as much as you can to flag the cool stuff you do in this instance (but go for it)!

Ernie