Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
you can please help me , I have a field name "rate".
I want to create a flag for in a field rows
rate |
---|
1d |
1e |
1c |
2a |
2g |
2k |
4 |
5 |
Thanks,
Ravi.
tried this still no luck
pick( 1+WildMatch(rate,'1*','2*'),
'Bom', 'Newb',rate) as Group;
Hi
Is it right result?
code:
[tmp]:
LOAD
Rate,
if (Left(Rate, 1) = '1', 'Born by Company', if (Left(Rate, 1) = '2', 'Born by vendor', Rate)) as _flag;
LOAD * INLINE [
Rate
1d
1e
1c
2a
2g
2k
4
5
];
load *,if(Left(Rate,1)=1,'Born by Company',if(Left(Rate,1)= 2,'Born by vendor',Rate))as Rate1 Inline [
Rate
1d
1e
1c
2a
2g
2k
4
5
];
EXIT SCRIPT ;
Youssef,
I think perhaps you meant to put the default (rate) as the first pick?
pick(wildmatch(rate,'1*','2*')+1, rate, 'Born by Company',' Born by vendor') as rate
-Rob
Thank so much for your time
try this on the graphic object...
if(pick(Left(Rate,1), 'Born by Company','Born by vendor',Rate) > 0,
pick(Left(Rate,1), 'Born by Company','Born by vendor',Rate), Rate)
Nice Rob thanks for the clarification