Latest Activity

code

SQL Query in a field expression

Hello, I am using Denodo 6.0 and wanted to find out if I can have a SQL query in a Field Expression of the field in a Derived View. I am looking for a instance of certain characters from a separate table (Table B) based on the value in the Field in T...

Expression

code

Field expressions guide

I'm trying to find a good guide on writing field expressions for new fields in derived views. I've looked through the admin, developer and advanced VQL guide and still can't find what I'm looking for. What I basically want to do is create a new field ...

Expression derived view Regular Expressions

code

Denodo logical expressions

Hello, I am being asked to create an Interface having following features 1st field: Only posible value are: 'I' and 'A' 2nd field: This would be a column in view. Populate as NULL 3rd Field: Should be 3 character code. 4th Field: Length of ...

Expression

code

How to set Value for 'Like' or Not Full Value

I am attempting to set an SetValue(^EncodeSeq(@County_Input)); My issue is that the drop down has the county name and the time it was updated. I need to know how to be able to select the value based on just the first word ignoring the time updated. ...

help set fix Expression function denodo error value