Q&A BY TAG 'CASE'

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

Condition based Join of 3 tables
answered 10-08-2021 13:41:59 -0400

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

Answers: 2

join CASE switch

Condition based Base view call
answered 28-07-2021 11:10:18 -0400

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

Answers: 1

CASE

Passing case statement as subquery in select statement.
answered 22-07-2021 17:57:43 -0400

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

Answers: 3

Denodo 7.0 Select Query CASE

Case statement using columns from two different tables in a business
answered 21-02-2020 03:59:17 -0500

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

Answers: 1

CASE

Case function in Denodo
answered 31-05-2019 07:54:56 -0400

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

Answers: 1
Related to: Oracle SQL to Denodo VQL Quick Reference

Function case function denodo functions CASE

Using Regexp_like in Case in Select
answered 27-09-2018 11:26:31 -0400

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

Answers: 2

REGEXP_LIKE Select Query CASE

ITPilot case function doesn't work fine
answered 21-08-2018 07:15:43 -0400

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

Answers: 2

ITPILOT CASE

Finished with error: Function 'ifnull' with arity 2 not found
answered 12-03-2018 09:01:29 -0400

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

Answers: 1

coalesce CASE

Converting value in a field
answered 22-08-2017 11:32:20 -0400

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

Answers: 2

Select field CASE

Case statements not giving expected results in Denodo
answered 28-04-2017 06:58:55 -0400

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

Answers: 1

CASE