I am running a job which reads from excel sheet and inserts data in a Table. I have a Reject flow which stores those records which do not match the data type. But for one record it is giving an exception in the console as in the screenshot below. So, how to handle this or catch such errors in a file/table so that if there 100 such records, they also get stored separately.
Ok, using tMap can always help in such matters. But i want to do something like let's say I put a rule to replace some characters with some other. At the end, if I wish to know from 100 records on how many records was the rule applied, something isRuleApplied column in Table or so. How to do this?