If Condition

[dseelam]

Hello,

   IF(CUSTNAME = 'AMAZON.COM', 'eCom Standard', ORDER_TYPE) ,

      If(CUSTNAME = 'e Supply', 'eCom Standard', ORDER_TYPE) as ORDER_TYPE

Some how only e Supply is falling under eCom Standard, Amazon.com is  falling under different order type

how to change the condition so that both customers fall under eCom standard?

Thanks

[vishsaggi]

Try this ?

   IF(Match(CUSTNAME, 'AMAZON.COM', 'e Supply'), 'eCom Standard', ORDER_TYPE)  as ORDER_TYPE

[vishsaggi · Accepted solution]

Or Try like

IF(CUSTNAME = 'AMAZON.COM', 'eCom Standard',

      If(CUSTNAME = 'e Supply', 'eCom Standard', ORDER_TYPE)) as ORDER_TYPE