Exception catch and reverting changes for excel source file

Anonymous — Tue, 12 Mar 2019 11:28:32 GMT

Dear Friends,

My source file is an excel file and I am loading this to talend and had generated BatchIds for every files.

My requirement is below:

Suppose some expression in tmap is running .... and at that time if any invalid data entry comes in to the source file then, 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.

Please help me....very urgent

Re: Exception catch and reverting changes for excel source file

DataTeam1 — Tue, 12 Mar 2019 21:19:51 GMT

You can create stage level compnent When you will insert rows for the particular batch id and if everything is OK you can transfer it from stage to target component (file od db Output). In this case you don't need to revert all changes from the target component when something goes wrong.

As a stage component you can use:

tHashInput

tHashOutput

To see it in your pallete read this: https://community.talend.com/t5/Migration-Configuration-and/Where-are-the-tHashInput-and-tHashOutput-components/ta-p/309

topic Exception catch and reverting changes for excel source file in Talend Studio

Exception catch and reverting changes for excel source file

Re: Exception catch and reverting changes for excel source file