We have requirement to age old data of entire schema(14000 tables) to 100 days. How to do the date pattern matching and update the date of 14000 tables.
There is a built-in function TalendDate.compareDate in talend. If you want to match date with a default date, you can join the both objects (main column and lookup column) in tMap.
Would you mind elaborating your case with an example with input and expected output values?