We use the free version of our powerful XML converter (Flexter Data Liberator) to parse ISO 20022 XMLs to text. Flexter generates multiple text files (TSV) as output from the XML.
We take the tab separated output from Flexter and show you how to load the data into Trifacta and join the data there. In a final step we show you how you can export the joined datasets to CSV
Find out more about Flexter, our powerful XML converter https://sonra.io/flexter-for-xml/
Try Flexter Data Liberator yourself https://flexter.sonra.io/
File used : https://sonra.io/wp-content/uploads/2017/07/CustomerCreditTransferInitiation-pain.001.001-2.zip