topic New to Talend Open Studio, need help in Data Quality

New to Talend Open Studio, need help

Anonymous — Sat, 16 Nov 2024 10:52:22 GMT

I'm new to Talend and i'm having some problems attempting to apply an user defined indicator in one of my analysis. I created an indicator that shows me the records that have less than 10 caracteres and when I try to run my analysis, it says it failed to run. I created a basic column analysis that analyzes a column that only contain names. The simple Simple Statistics indicators and Text Statistics indicators work, but the others don't. I'm also trying to understand the templates that Talend use for coding in SQL, because it looks a little different.

The code I want to work on the indicator is:
SELECT * FROM TabelaFonte
WHERE LEN (Nome) < 10

I hope you can help me, thank you!

Re: New to Talend Open Studio, need help

Franz3 — Mon, 11 Jan 2016 14:27:26 GMT

Your request is not really clear, tell us what is not working pls, like a capture

Re: New to Talend Open Studio, need help

Anonymous — Tue, 12 Jan 2016 11:33:24 GMT

Here's the expression I wrote on the expression editor of my user defined indicator. Don't know if it is correct. I want the indicator to count all the records with less than 10 characters, letters/numbers.

And when I try to run my analysis, I got this error:

Then I go to the error log and it shows me this:

I searched for this error, but nobody seems to have resolved. If it is not clear enough yet, please, let me know 😕