Latest Activity

code

Creating new field in derived view using conditional logic

Hello. I have created a derived view named 'dv_1' based on a base view named bv_1. I need to create a new column named 'new_col' in the derived view 'db_1' using conditional logic. The values in the new column 'new_col' depend on the values of two a...

VQL simple condition CASE Clause condition #CASE

code

like vs contains

What's the different between like and contains under simple condition when create selection view?

VQL simple condition

code

Common Table Expression (CTE) getting an error

Hi, i'm converting my CTE codes from SQL server to Denodo/VQL but i'm getting an error it say "QUERY VIRTUAL ERROR". I have a multiple CTE's in my script but when i use a left join in my final query using the result of CTE i'm getting an error and some...

VQL VQL simple condition DENODO