Example using passthrough columns

The output mode is Aggregate all rows, which generates one output row unless there is a passthrough column. ZONE is the passthrough column, and the output column CUSTOMER uses the forward slash (/) as the Description property. Here are the input rows.

CUSTOMER DIVISION CITY ZONE

Acme

Toys

Boston

East

Acme

Toys

New York

East

Acme

Chemical

Raleigh

East

Acme

Chemical

St. Louis

Midwest

The root filename acme.xml is used because only one output column is involved in the transformation. XML Output generates two output files, acme.xml and acme_1.xml, because the ZONE value changes in the fourth input row. The ZONE values are written on the output link but not to the output files.