Hi, I have to implement solution for this situation: I have 4 files: A, B, C, D. File A contains data - some IDs, date and more (csv) File B contains a list of forbidden chars, suggested replacement and date from the char is forbidden (xlsx) File C contains list of good IDs (csv) File D contains list of good IDs (csv)
Things which I have to implement at Talend Studio: 1. I want to check if IDs from file A contains char from file B (also date from file A is higher than date from file B) 2. If ID contains forbidden char, it should be suggested to replace with char from file B and check if correction exist in file C or D. If exist replacement should be done. 3. If there is no ID with replaced char in files C or D it has to be checked if IDs without replacement exist in C or D.
I hope that I described it logically. As I have no experience in developing in Talend I would be grateful for any help.
