Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

New to Talend Open Studio, need help

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! 
   

Labels (2)
2 Replies
Franz3
Contributor III
Contributor III

Your request is not really clear, tell us what is not working pls, like a capture
Anonymous
Not applicable
Author

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. 

0683p000009MGkd.png

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

0683p000009MH3S.png

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

0683p000009MGyO.png

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