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
xpath Metadata Importer Stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 612
- Joined: Thu May 03, 2007 4:59 am
- Location: Melbourne
You can use Nested XPath Expression in XML stage.
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
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
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
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>