I want to create a flags in the field values

[ravikumar_iyana]

Hi ,

you can please help me , I have a field name "rate".

I want to create a flag for in a field rows

1. Startig the field with "1" means i will show to "Born by Company".
2. Startig the field with "2" means i will show to "Born by vendor"
3. Remaining same numbers will display.

rate
1d
1e
1c
2a
2g
2k
4
5

Thanks,

Ravi.

[Chanty4u]

tried this still no luck

pick( 1+WildMatch(rate,'1*','2*'),

                   'Bom', 'Newb',rate) as Group;

[sergeyay]

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

];

[chinnuchinni]

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 ;

[chinnuchinni]

[rwunderlich]

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

[YoussefBelloum]

Thank so much for your time

[Anonymous]

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)

[Chanty4u]

Nice Rob thanks for the clarification