Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi ,
Need help.
PFA
my reuirment is from ORDER_BOOK field i want above 60min between10&30min,between 30&45min
using if Else condition ony nt usng interval match fun
Thank you
suresh
if (ORDER_BOOK_TO_OSN_TIME<10,'less than 10 minutes',if(ORDER_BOOK_TO_OSN_TIME>=10 and ORDER_BOOK_TO_OSN_TIME<=30,'between 10 & 30 minutes',if(ORDER_BOOK_TO_OSN_TIME>30 and ORDER_BOOK_TO_OSN_TIME<=45,'between 30 & 45 minutes',if(ORDER_BOOK_TO_OSN_TIME>45 and ORDER_BOOK_TO_OSN_TIME<=60,'between 45 & 60 minutes',if(ORDER_BOOK_TO_OSN_TIME>=60 ,'above 60 minutes'))))) as Interval