https://community.qlik.com/t5/Talend-Studio/Compare-string-with-a-list-and-replace-or-not/m-p/2199412#M2331 <P>Hi, I have to implement solution for this situation:&nbsp;<BR />I have 4 files: A, B, C, D.<BR />File A contains data - some IDs, date and more (csv)<BR />File B contains a list of forbidden chars, suggested replacement and date from the char is forbidden (xlsx)<BR />File C contains list of good IDs (csv)<BR />File D contains list of good IDs (csv)<BR /><BR /></P> <P>Things which I have to implement at Talend Studio:<BR />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)<BR />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.<BR />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.<BR /><BR />I hope that I described it logically. As I have no experience in developing in Talend I would be grateful for any help.&nbsp;&nbsp;</P> Sat, 16 Nov 2024 04:23:51 GMT Anonymous 2024-11-16T04:23:51Z https://community.qlik.com/t5/Talend-Studio/Compare-string-with-a-list-and-replace-or-not/m-p/2199412#M2331 <P>Hi, I have to implement solution for this situation:&nbsp;<BR />I have 4 files: A, B, C, D.<BR />File A contains data - some IDs, date and more (csv)<BR />File B contains a list of forbidden chars, suggested replacement and date from the char is forbidden (xlsx)<BR />File C contains list of good IDs (csv)<BR />File D contains list of good IDs (csv)<BR /><BR /></P> <P>Things which I have to implement at Talend Studio:<BR />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)<BR />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.<BR />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.<BR /><BR />I hope that I described it logically. As I have no experience in developing in Talend I would be grateful for any help.&nbsp;&nbsp;</P> Sat, 16 Nov 2024 04:23:51 GMT https://community.qlik.com/t5/Talend-Studio/Compare-string-with-a-list-and-replace-or-not/m-p/2199412#M2331 Anonymous 2024-11-16T04:23:51Z https://community.qlik.com/t5/Talend-Studio/Compare-string-with-a-list-and-replace-or-not/m-p/2199413#M2332 Can you share sample data for each file and expected result? Mon, 14 Oct 2019 12:19:47 GMT https://community.qlik.com/t5/Talend-Studio/Compare-string-with-a-list-and-replace-or-not/m-p/2199413#M2332 TRF 2019-10-14T12:19:47Z