Q&A BY TAG 'Expression'

You must sign in to ask a question. If you do not have an account, you can register here

SQL Query in a field expression
answered 03-10-2018 04:20:18 -0400

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...

Answers: 3


Field expressions guide
answered 30-03-2017 06:53:24 -0400

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 ...

Answers: 4

Expression derived view Regular Expressions

Denodo logical expressions
answered 29-06-2015 13:58:41 -0400

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 ...

Answers: 1


How to set Value for 'Like' or Not Full Value
answered 03-10-2014 07:47:38 -0400

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. ...

Answers: 2

help set fix Expression function denodo error value