Create new field with if logic

[mahitham]

Hi Experts,

Can any one please help me to create a new field called

Section with records 'Electronics Section', 'Clothes Section', 'Vehicles Section' from Product, Clothes and Vehicles fields

based on below conditions.

if [Product] is TV,Refrigerator then its  'Electronics Section'

if [Clothes] is Cotton and [Brand] is Asian,Raymond, Allen Solly then its 'Clothes Section'

if [Vehicles] is Car, Bike and Type is Tata,Maruthi then its 'Vehicles Section'

Please help me on this.

Thanks in advance.

[sunny_talwar]

Are you looking to create one new field or 3 different fields?

[rubenmarin]

Hi Mahitha, if Product, Clothes, Brand and Vehicles are fields in the same table the sentence, to create the new field it can be:

LOAD

  If(Match(Product, 'TV', 'Refrigerator'), 'Electronics Section',

    If(Clothes='Cotton' and Match(Brand, 'Asian', 'Raymond', 'Allen Solly'), 'Clothes Section',

     If(Match(Vehicles, 'Car', 'Bikes') and Match(Type, 'Tata', 'Maruthi'), 'Vehicles Section'))) as newField,

OtherFields...

From/resident...

[mahitham]

Hi sunny

Based on above conditions need to create one field named section