I need to update specific column (and cell if possible) of excel sheet once all operations completed into the pipeline.
e.g.
Read Excel sheet1 → excel parser → mapper → REST POST–> need to update sheet1 column c with status “Completed”
Please suggest which snap will be helpful.
Hello,
The batches is managed by Pipeline Execute.
That complicates things a little bit. You can keep track of processed files in a file, so the next execution will know what number to use. But that will significantly slow down your pipeline 🙂
If there are no concurrent executions of the pipeline, you can simply write down a file with the sequence number used, and set that file as a library expression on the child pipeline itself, so you could easily set the next value:
Example expression in the file writer: "TEST_" + lib.config.sequence + 1 + ".txt"
