BatchId Creation

[Anonymous]

Hi,

Initially my source file don't have any batch ids.

I want to create Batch Id for my source files. 

One file having one Batch Id, another file having another Batch Id like that.

Can I create a BatchId using filename or Time stamp or any unique number?

How to generate batch Id for every file?

Please help friends

[Anonymous · Accepted solution]

Hello,

If we understand your requirement very well, you could add an Integer field to your schema and populate it using Numeric.sequence.
For example, Numeric.sequence("s1", 1)

Let us know if it is what you are looking for.

Best regards

Sabrina

[Anonymous]

That was helpful. So now I got Batch Ids.
Now, if any invalid data comes in the source file, I need to stop the execution in between and need to revert all changes for that particular batch id.
For this, I did a tcatch component but...it only catches the exception.

How can I revert /delete all changes for that particular batch id exception in talend??
My source file is an excel file