Skip to main content Skip to complementary content

Splitting a file into several outputs

Filter records in an XML file and write the output to three different CSV files.

About this task

This example uses the following XML sample as input:
<orders>
   <order>
      <orderId>ih3fPC</orderId>
      <lastName>Chester</lastName>
      <firstName>Harding</firstName>
      <region>US</region>
   </order>
   <order>
      <orderId>vF7lNh</orderId>
      <lastName>Bill</lastName>
      <firstName>Madison</firstName>
      <region>EMEA</region>
   </order>
   <order>
      <orderId>l7xZ4P</orderId>
      <lastName>George</lastName>
      <firstName>Harding</firstName>
      <region>APAC</region>
   </order>
   <order>
      <orderId>dTTrNO</orderId>
      <lastName>Abraham</lastName>
      <firstName>Roosevelt</firstName>
      <region>US</region>
   </order>
   <order>
      <orderId>wZlWOj</orderId>
      <lastName>William</lastName>
      <firstName>Quincy</firstName>
      <region>APAC</region>
   </order>
</orders>

The goal of the transformation is to split this file based on the value of the region element.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!