topic CASE..WHEN expression in Qlik Data Catalyst i.e. Data Catalog within Data Prep in Catalog and Lineage

CASE..WHEN expression in Qlik Data Catalyst i.e. Data Catalog within Data Prep

akshaye_c_navale — Tue, 07 Dec 2021 22:35:04 GMT

Hi Community,

In one of my Data Prep Data Flow i want to convert below ternary expression into CASE..WHEN expression.

( TO_INTEGER ( Row_ID ) > 300 ? '>300' : ( TO_INTEGER ( Row_ID ) > 100 ? '>100' : 'Others') )

Can you please help me to write CASE..WHEN expression since i have multiple conditions.

Does anyone know how to create range buckets?

Thanks,
Akshaye

felcar2013 — Mon, 06 Jul 2020 12:55:48 GMT

hi, maybe this..

IF( Row_ID > 300, '>300',

IF( Row_ID > 100 AND Row_ID <= 300, '>100' ,

'Others') ) AS YOUR_FIELD_DIM

_range buckets, depends how do want to use it, maybe a new table, have you checked interval match?

best

akshaye_c_navale — Mon, 06 Jul 2020 13:04:25 GMT

Thanks for reply.
I am looking to implement it within Qlik Data Catalyst.

Thanks,
Akshaye