Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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"
I think you're looking for soemthing like this:
if([Brand]='ss' or [Brand]='sp' or [Brand]='sm','samsung'
Hi,
maybe & instead of +
'ss'&'sp'&'sm' -> ssspsm.
However i'm not sure this is what You need.
Regards,
Antonio
What is the expected meaning or using + ?? Is it if ([Brand]= 'ss' or 'sp' or 'sm', 'Samsung', 'Others') ?
I think you're looking for soemthing like this:
if([Brand]='ss' or [Brand]='sp' or [Brand]='sm','samsung'
Hi,
Try
if ([Brand]='so', 'sony', if([Brand]='lg', 'lg',if([Brand]='ss' Or [Brand]='sp' Or [Brand]='sm','samsung', 'Other'))) as "Brand name"
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')
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
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!
Hi,
where ever in that field it says 'ss' or 'sp' or 'sm' they should go under 'samsung'.
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]