I've been trying put a system to check special characters for all primary keys of every tables
My idea is to use tMap, i should create a routine to check if a primary key contains at least 1 special character. If yes, it won't be integrated and be rejected, its data will be kept in tHashOutput
The point is i can't find the condition by which i could check the special characters ...
In attachment you can find the screenshot of my tMap, i should check OTI_Source. in case it contains a special character, i must put it to reject / KO
Do you have any idea about the condition i should put or another way to verify this case?
Thank in advance
Solved! Go to Solution.
Thank for your reply,
Creating a new routine seems a best method so far to resolve my question. The site you attached is quite helpful
Fresher in talend so this community is the gold mine for me
Have a good day