Output columns

The sample input XML maps to four output columns:

Column XPath
CUST_ID /customers/customer/@id
NAME /customers/customer/name/text()
STREET /customers/customer/address/street/text()
CITY /customers/customer/address/@city

Repetition path: /customers/customer/@id