Using + in If function

[madhuqliklondon]

I am trying to divide the column data into filter value can I use + with if example: can  I use the following script??

if ([Brand]='so', 'sony', if([Brand]='lg', 'lg',if([Brand]='ss'+'sp'+'sm','samsung', 'Other'))) as "Brand name"

[antoniotiman]

Hi,

maybe & instead of +

'ss'&'sp'&'sm' -> ssspsm.

However i'm not sure this is what You need.

Regards,

Antonio

[sergio0592]

What is the expected meaning or using + ?? Is it if ([Brand]= 'ss' or 'sp' or 'sm', 'Samsung', 'Others') ?

[stigchel · Accepted solution]

I think you're looking for soemthing like this:

if([Brand]='ss' or [Brand]='sp' or [Brand]='sm','samsung'

[ahaahaaha]

Hi,

Try

if ([Brand]='so', 'sony', if([Brand]='lg', 'lg',if([Brand]='ss' Or [Brand]='sp' Or [Brand]='sm','samsung', 'Other'))) as "Brand name"

[effinty2112]

Hi Madhu

try:

Pick(Match(Brand, 'so','lg','ss','sp','sm'),'sony','lg','samsung','samsung','samsung')

Edit: to take care of 'Other'

Pick(1+Match(Brand, 'so','lg','ss','sp','sm'),'other','sony','lg','samsung','samsung','samsung')

[jmvilaplanap]

Hi, Madhu

I think you must to split the values of "Samsung", you mus to write this

if ([Brand]='so', 'sony', if([Brand]='lg', 'lg',if([Brand]='ss' or [Brand]='sp' or ='sm','samsung', 'Other'))) as "Brand name"

Regards

[juan_patrick]

Hi Mafhu!

Try this:

if (match([Brand],'so'), 'sony',

    if(match([Brand]='lg'), 'lg',

       if(match([Brand], 'ss', 'sp', 'sm'),'samsung', 'Other'))) as "Brand name"

¡Good luck!

[madhuqliklondon]

Hi,

where ever in that field it says 'ss' or 'sp' or 'sm' they should go under 'samsung'.

[stigchel]

Instead of the nested if's it would be better practice to use a map for this:

Map:

Mapping Load * Inline [From, To

'so', 'sony'

'lg', 'lg'

'ss','samsung'

'sp','samsung'

'sm','samsung'

];

And then where you load the brand field use

Applymap('Map',BrandField,'Other') as [Brand name]