topic Re: BatchId Creation in Talend Studio

BatchId Creation

Anonymous — Tue, 12 Mar 2019 06:42:41 GMT

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

Re: BatchId Creation

Anonymous — Tue, 12 Mar 2019 07:01:06 GMT

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

Re: BatchId Creation

Anonymous — Tue, 12 Mar 2019 11:22:11 GMT

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