Resetting sequence in XML graph file

CloverDX Platform
1

is there an XML attribute in the Sequence element of the Graph XML file, that
will reset the sequence to the start value each time I execute the graph?

In other words, each time I execute my graph, I want my sequence to start from initial value of 1, instead of continuing from the last value of the sequence. I know this is possible from the clover GUI, but I want to know if it is possible to reset from the XML graph file.

thanks.

2

Hi, it is not possible, but if you want to add record counter on reader you can use auto_filling described on Field formats and other goodies or do workaround like that: add new phase, which is executing before the rest of graph: SystemExecute or JavaExecute component, which deletes sequence file.

3

Sequence can be reset from inside Clover Transformation Language (CTL/TL).
CTL can be executed as part of Reformat, Join and other components.

This would be the CTL statement which would do it:

sequence(mysequence).reset

Deleting the sequence file is also possible, but a bit brutal. The auto-fill option seems to be the best for this simple situation.