I'm using SQL patterns to check if an URL is correct. When I execute the analysis I get the correct statistics, when I hover over the pattern in the analysis settings Talend shows me the right query.
Now here is the thing that confuses me. When I want to check the invalid/valid values Talend changes the query in the SQL editor to a REGEXP_LIKE where it should be LIKE.
How should I fix this?
Try Talend Cloud free for 30 days.
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.