Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
Can anyone think of a reason why the Len function doesn't work in SQL I'm using LEN(fieldname) just keeps telling me the function does not exist 😕
Thanks Max_dreamer I think its getting there I don't understand why its giving me two lines what do you think could be causing it ?
Hi,
When you use Join then there is possibilty of creating extra line,
Therefore when you use join in SQL you must use
1=1 which gives data only get true value.
Regards
What 'dialect' of SQL are you using? i.e. what is the database engine? Some dialects use len() others length(). Might be just as simple as that
Thanks I've put in code as above but is still giving me two lines, not sure why.
Sorry about this !
can u try, on dimension tab check the check box Suppress When the value is null?
Im not using dimentions on this table having the same problem still anyone got any ideas ?
For example I'm getting this at the moment but I'm trying to show on one row - When I select don't show null values it is hiding the entire row so nothing is showing 😕
load
service_id
MaxString(parameter_flag1) as parm_1,
MaxString(parameter_flag2) as parm_2,
......
resident <your_table>
GROUP BY service_id
Tha will put all values on 1 line
Regards,
HP
Thanks Hans there's a lot of linking statements is there a way I can do that without loosing that, I tried maxstring in the script and it returns function not recognised 😕 but seems to work in front end