transform ID in XML file into string from relational
We have an XML file that contains an element with an ID.
This ID gets sent from a 3rd party system and due to the 3rd party making changes recently, they have now added a 2nd XML file which has all the IDs and a 2nd code.
These XML files are consumed by a downstream system.
Is there a way to use an XLST to transform the Bank_ID in the first file and replace i with AAA12345 so we get:
We cannot so this in the downstream database due to coding difficulties and cost.