DSXchange

Output mode needs to be 'Use trigger column' if you want a change in value of that field to drive filename changes in the output.

chulett wrote:Output mode needs to be 'Use trigger column' if you want a change in value of that field to drive filename changes in the output. ...

Thanks for your inputs.
Tried using this option but in this case some of the tags could repeat:

<directory>
<customer name="Acme" zone="East">
<division>Toys</division>
<city>Boston</city>
<city>New York </city></customer>
</directory>

whereas what I am looking for is an output like:

<directory>
<customer name="Acme" zone="East">
<division>Toys</division>
[b<city>New York </city>[/b]</customer>
<customer name="Acme" zone="East">
<division>Toys</division>
<city>Boston</city></customer>
</directory>
considering that zone content triggers/changes to change the o/p rows accordingly.

Is that possible using xml?

Clearly no. What file name could be generated if the file name were to be based on a repeating element?!

You have no control over how it builds multiple filenames, other than supplying the 'base' name. It will then, from the second file generated onwards, append an '_?' number to that.

The trigger column controls when the current file is closed and a new one opened. Where you put the Key column is what controls the repeating element.