topic Re: CASE Statement while loading the data from the qvd in Visualization and Usability

CASE Statement while loading the data from the qvd

CK_WAKE — Wed, 24 Apr 2024 04:04:06 GMT

Hi There,

I want to apply similar SQL case statement as below in the QVD while loading the data. Please guide me. Thanks.

CASE
WHEN RAISED_DATE < TO_DATE('30-06-2016', 'DD-MM-YYYY') THEN TO_DATE('01-07-2016', 'DD-MM-YYYY')
ELSE RAISED_DATE

END AS RAISED_DATE_MIN

Re: CASE Statement while loading the data from the qvd

Anil_Babu_Samineni — Wed, 24 Apr 2024 05:29:57 GMT

Perhaps this?

Load * From <<Table>>
Where RAISED_DATE > Date('30-06-2016', 'DD-MM-YYYY') and RAISED_DATE <=Date('01-07-2016', 'DD-MM-YYYY');

Re: CASE Statement while loading the data from the qvd

CK_WAKE — Wed, 24 Apr 2024 05:46:21 GMT

Hi Anil, Thanks for getting back.
I dont want to apply a data filter, what i want to achieve is

if raised_date < less than '30-06-2016' , then input the date as 01-07-2016 otherwise keep the date of raised_date, and I am creating a new column as RAISED_DATE_MIN for this condition. Let me know if i am not clear about this.

RAISED_DATE < TO_DATE('30-06-2016', 'DD-MM-YYYY') THEN TO_DATE('01-07-2016', 'DD-MM-YYYY')
ELSE RAISED_DATE

Re: CASE Statement while loading the data from the qvd

Anil_Babu_Samineni — Wed, 24 Apr 2024 06:05:15 GMT

Try this if you want as field name

if( raised_date < date('30-06-2016' ), date( 01-07-2016), raised_date) as RAISED_DATE_MIN

Re: CASE Statement while loading the data from the qvd

CK_WAKE — Wed, 24 Apr 2024 06:25:37 GMT

Thanks Anil, it worked. Cheers