Latest Activity
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 ...
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...
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 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...
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
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 ...
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...
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...
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...
When I execute the below logic in TOAD in the SELECT statement, I get proper expected result but when I put the same logic in Denodo View for one of the output columns, the result set doesn't match with what Toad is returning: ((((trim(tr_tran_short_d...