How to change values in a column?

[posywang]

Hi,

I need to change value in "Owner" column to Tom where Fruit contains "Apple". How can I do it? Thanks!

Fruit	Owner
Green Apple	Sam
Red Apple	Linda
Green Kiwi	Nancy
Yellow Banana	Mary
Yellow Pineapple	John
Red Strawberry	Mary

[sunny_talwar · Accepted solution]

May be like this:

If(WildMatch(Fruit, '*Apple*'), 'Tom', Owner) as Owner

[sunny_talwar]

Or this:

If(Index(Fruit, 'Apple'), 'Tom', Owner) as Owner