help

[vinod2086]

Hi Team ,

please find below  in that i have 2 columns status and type. my issue is if status is completed then type should be "Enterprise" how to change standard to enterprise

status		type
complete		standard
complete		standard
complete		standard
complete		Enterprise
complete		Enterprise
complete		Enterprise
complete		standard

Thanks in Advance.

[vinod2086]

Hi Manish,

i have one more situation PFB

status	type
complete	standard
complete	Enterprise
complete	standard
pending	standard
pending	standard

for complete cases we had done and pending cases i want to display NEW instead of standard . both conditions should be at single place any new idea.

[sunny_talwar]

‌try this:

     If(status = 'complete','Enterprise',

If(status = 'pending', 'NEW', type)) as type

[sorrakis01]

Hi,

If(Status='complete','Standard',

     If(Status='pending','Standard', Type) as Type

regards

[vinod2086]

Thanks sunny..