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: 
hopkinsc
Partner - Specialist III
Partner - Specialist III

Using Len() in the script on a field with a number as a name

Hi all, 

Is there a work around for using the LEN() function in the script on a field that has a numeric name?

Basically, i have a field with the name of 201901, and if i try and use an IF(LEN()) in the script it returns the wrong result but if i change the field name to be 'FIELD' then the if statement returns the correct result. 

Any ideas?

I have attached an example. 

1 Solution

Accepted Solutions
sunny_talwar

Use square brackets around the field name

 

If(Len([201901]) > 0, 'Yes', 'No') as Complete

 

View solution in original post

2 Replies
sunny_talwar

Use square brackets around the field name

 

If(Len([201901]) > 0, 'Yes', 'No') as Complete

 

hopkinsc
Partner - Specialist III
Partner - Specialist III
Author

!!! i can't believe it was that easy!!

Thanks!