Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I use the following Substring in an SQL statement in a few different apps and it works as expected:
Substring(Upper(Coeuser),10,100)as `MgrCoeuser`
I've created a new app and am trying to reuse the string above and I'm receiving the following error(see image):
If I remove the Substring statement the data load completes without any issues.
Do you do the above within the LOAD statement or SELECT statement? I guess other dashboards might do it in LOAD and this one is doing in SQL SELECT.
This is located in the SELECT statement. When I try putting it in the LOAD it highlights the statement as an error.
Can you share the old and new script (just the load for a single table is enough)
What database platform are you connecting to?
-Rob