I am trying to create an XSLT (1.0) that transforms information for the following schemas:
These are simplified schemas but they represent the root of my issue. Please not that there can be multiple "Account" nodes in the source and multiple "ServiceCode" nodes in the destination. I can easily map these two schemas using XSLT. There are times when more than one "Account" nodes will be present for the same "ServiceCode" but the start and end dates are different. In this situation, I want to update the "Code" node in the destination to reflect something like "--SERVICECODE FROM SOURCE-- PLEASE REVIEW DUE TO DATE MISMATCH." Can anyone help with this? Thank you!