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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
_AnonymousUser
Specialist III
Specialist III

How to use tmap filter for below condition

I need help in writing the below SQL format into talend tmap filter condition format 

isnumeric([size=2][font=Courier New]columnA)=1 and len(columnA) = 12[/font][/size]

Labels (2)
2 Replies
_AnonymousUser
Specialist III
Specialist III
Author

NUM(InsertConsumer.IntegrationCode):1 && LEN(IntegrationCode):12

will this work?
Anonymous
Not applicable

Hi,
What does your job look like? Elaborating your case with an example with input and expected output values will be preferred.
Best regards
Sabrina