Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Are you looking to create one new field or 3 different fields?
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...
Hi sunny
Based on above conditions need to create one field named section