Latest Activity

code

Mixed Case

Hello. Does Denodo have a function that converts the values of a column into mixed case? Thank you.

CASE

code

Condition based Join of 3 tables

I am having 3 tables - A, B, C. I need 4 kinds of output Case 1 : If condition 1 and 2 both not satisfied : Sel from A Case 2 : If condition 1 satisfies : Sel A. from A Inner Join B Case 3 : If condition 2 satisfies : sel A. from A Inner Join C Case ...

join CASE switch

code

Condition based Base view call

I am having 3 base views : A, B, C. I need to create a single business view (D) based on the below condition. Please let me know how to achieve this use case : If (Condition 1 satisifed) Then Base view A's should be displayed as D's output Else Base v...

CASE

code

Passing case statement as subquery in select statement.

We are automating function to get prior two business days excluding weekends using below logic : select * from dw_vdb.cib360_bv_daily where as_of_date in (select case getdayofweek(current_date) when 3 then addday(current_date, -4) when 2 then addday(c...

Denodo 7.0 Select Query CASE

code

Case statement using columns from two different tables in a business

Denodo Virtual DataPort Version 7.0 Hi. I've written a case statement in a computed field in a business view which includes references to columns from two different tables. The case statement is returning results for one table or the other but not bot...

CASE

code

Case function in Denodo

Hi Team, I have a requirement to implement a scenaion similar to the below in Denodo. But I am not sure, how to go about it using denodo case function. It is throwing me some error. Can you please help? IF [varI] =0 then 'Perm' ELSEIF([varI] >0 and ...

Related to: Oracle SQL to Denodo VQL Quick Reference

Function case function denodo functions CASE

code

Using Regexp_like in Case in Select

Question about CASE in the SELECT statement of query. I have this in Oracle. CASE WHEN REGEXP_LIKE (UPPER (MAIN_PRODUCT), 'CBMCLS|CBMOT|CBMSHG') THEN REGEXP_REPLACE (UPPER (MAIN_PRODUCT), 'CBMCLS|CBMOT|CBMSHG', 'CBM') ELSE UPPER(MAIN_PRODUCT) END AS ...

REGEXP_LIKE Select Query CASE

code

ITPilot case function doesn't work fine

Hi! I am working with ITPilot wrapper trying to process output record and create a new field with into a value editor. I have a field date as string and I try to format with two patterns (with and without hours) case max(indexof(Iterator_1_output.dat...

ITPILOT CASE

code

Finished with error: Function 'ifnull' with arity 2 not found

This is my query which I am trying to use in VQL Shell "SELECT srno_0, employeeid, firstname, lastname, country, Coalesce ( CASE WHEN Country= "USA" THEN (concat(ifnull(substr(SSN,1,3), ''), '-XX-XXXX')) end, CASE WHEN Country!= "USA" THEN (concat(ifn...

coalesce CASE

code

Converting value in a field

Hello there, I am currently trying to add a projection to a dervied view that checks the values of two fields and if they are equal then the values for one of the fields shoud be turned into an empty string. I was wondering if any one can give me a ha...

Select field CASE