Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
smilingjohn
Specialist
Specialist

Where

HI ALl

I am trying to acheiev in the script by using this match functionlity and when i reload it gives me the error

where match([Scheduled for Release],'17.1','17.2','17.3','17.4','17.5','17.6','17.7','17.8','17.9',,'17.10','17.11','17.12');

Can someone suggest me on this

4 Replies
zhadrakas
Specialist II
Specialist II

where match([Scheduled for Release],'17.1','17.2','17.3','17.4','17.5','17.6','17.7','17.8','17.9'

,,

'17.10','17.11','17.12');

try to remove one of the red commas

arvind_patil
Partner - Specialist III
Partner - Specialist III

Hi John,

Please Try Below:

where match([Scheduled for Release],'17.1','17.2','17.3','17.4','17.5','17.6','17.7','17.8','17.9','17.10','17.11','17.12');



Thanks,

Arvind Patil

Chanty4u
MVP
MVP

try this as Arvind Patil   suggested,


But u feel still the error it is the issue with the case sensitive of the filed " Scheduled for Release"  check for the gaps and case

where match([Scheduled for Release],'17.1','17.2','17.3','17.4','17.5','17.6','17.7','17.8','17.9','17.10','17.11','17.12');

ramasaisaksoft

Hi John,

unfortunately you type one more [ , ] after the value

match([Scheduled for Release],'17.1','17.2','17.3','17.4','17.5','17.6','17.7','17.8','17.9',,'17.10','17.11','17.12');


so remove one coma and check.