Subject:How do I do something similar to an Outer Join using XSLT 1.0 Author:Samz Sammy Date:23 Jul 2007 10:22 AM Originally Posted: 23 Jul 2007 10:20 AM
Hi friends
I have a requirement wherein I have to merge 2 nodes, lets say <ABC> and <XYZ>. Both have common elements/fields called AMOUNT, DATE, INVOICEID and CUSTOMERID.
My where clause would be something like this,
ABC."DATE"=XYZ."DATE" and
ABC.CUSTOMERID=XYZ.CUSTOMERID and
ABC.INVOICEID=XYZ.INVOICEID
But it should be like an outer join on XYZ, i.e if there is no value in the ABC then the value from XYZ should be picked, else the normal where condition should take place.
Subject:How do I do something similar to an Outer Join using XSLT 1.0 Author:Samz Sammy Date:24 Jul 2007 11:01 AM Originally Posted: 24 Jul 2007 10:34 AM
Thanks James
But ABC and XYZ nodes can occur multiple times. So how do we handle it in that scenario.
I am attaching the input xml.
In this input, I have to merge the MakeRows and ZZBCM_RULE node, the common element to do a left outer join on MakeRows is LINETYPE, and my WHERE clause would be something like,
(MakeRows.LINETYPE = ZZBCM_RULE.LINE_TYPE AND MakeRows.AMOUNT != '0.00') OR (MakeRows.AMOUNT_TALLIED != '0.00' AND MakeRows.AMOUNT = '0.00')