Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a column called Order_Tyoe where data are present as 'RGA001', 'ABC002', 'DEF03' in this way.
I want to create a calcuation like this one -- if substring (Order_Type), 3,0) = 'RGA' then 0 else 1
Not able to figure out which string function should I use.
May be this
If(Left(Order_Type, 3) = 'RGA', 0, 1) as Flag