[Video] Convert XML to Trifacta

Uli Bethke XML

Converting XML to Text in Flexter. Wrangling with the Output in Trifacta

In this video we will show you how Flexter's powerful XML Converter and Trifacta's powerful data preparation tool work hand in hand to liberate and analyse data that is locked away in obscure XML files.

One of the great things about Trifacta is that they have a free personal edition for download. This makes it the perfect match for wrangling and analysing the output from Flexter.

In the video we go through the following sequence of steps

  • Upload some complex ISO 20022 XML files to the free version of Flexter
  • Convert the XML to text files (Tab Separated Values, TSV)
  • Import the text files to Trifacta
  • Join the data in Trifacta
  • Export the joined data to CSV

You can download the ISO 20022 XML files that we use in the video from our website.

CustomerCreditTransferInitiation pain.001.001 (2)

Which data formats apart from XML also give you the heebie jeebies and need to be liberated? Please leave a comment below or reach out to us.

About the author

Uli Bethke LinkedIn Profile

Uli has 18 years’ hands on experience as a consultant, architect, and manager in the data industry. He frequently speaks at conferences. Uli has architected and delivered data warehouses in Europe, North America, and South East Asia. He is a traveler between the worlds of traditional data warehousing and big data technologies.

Uli is a regular contributor to blogs and books, holds an Oracle ACE award, and chairs the the Hadoop User Group Ireland. He is also a co-founder and VP of the Irish chapter of DAMA, a non for profit global data management organization. He has co-founded the Irish Oracle Big Data User Group.