Q&A BY TAG 'CASE'

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

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

How many CASE statements are allowed in one view?
answered 24-11-2014 10:56:02 -0500

Hi I have a question regarding the CASE statement and how many can be used in creating a view. I have two views joined in a UNION. I have multiple fields where I have applied the following statement: Case WHEN (view1.field1 is null) THEN view2.fiel...

Answers: 1

UNION CASE