Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi @felcar2013 ,
Thanks for reply.
I am looking to implement it within Qlik Data Catalyst.
Thanks,
Akshaye