Hi,
I think you can use Expression Language to do this, using the Grouping functionality. This requires records to be sorted on the Cluster ID first.
Add an Expression node to your job
In the Grouping tab, select your cluster ID field in the "Group By" box at the top. The Expression node will now group your records by Cluster ID.
In the Pre-group Expression tab (=the actions that will happen before a new cluster ID group), you'll have to create a reference to the file and open it:
file output
string filepath
//change the filepath to the place where you want to save your files
filepath = "C:\"&`Cluster ID Field Name`&".txt"
//this opens the file in Write mode
output.open(filepath, "w")
In the Post-group Expression, you will close the file:
output.close()
In the Expression code itself, you'll write the lines to the file that was opened for this Cluster ID group:
output.writeline(`My Field 1`)
This will create as many files as Cluster ID you have, as you can see in my example screenshot below:
Hope this helps.
Audrey
... View more