RE;Replace...?

[Chanty4u]

hi all,

i have data lik  complxcity values 2,4,8.

filedname :cmplexity

and i want to replce  2 as simple, 4 as expect, 8 as common

how can i achive in script?

thnks in advance...

[sunny_talwar]

May be this:

Pick(Match(cmplexity, 2, 4, 8), 'simple', 'expect', 'common')

[Anonymous · Accepted solution]

like this?

if(Complexity=2, 'Simple',

if(Complexity=4, 'Expect',

if(Complexity=8, 'Common'))) as NewField

[Kushal_Chawda]

=Pick(Match(cmplexity,'2', '4','8'), 'simple', 'expect', 'common') as Complexity_new

[HirisH_V7]

Hi ,

Like this,

T:
REPLACE ONLY LOAD * INLINE [
    Type, Value
    Simple, 2
    Expect, 4
    Common, 8
   ];
T:
LOAD * INLINE [
    Type
    Simple
    Expect
    Common and Other
];

It Helps for large data sets,

Hope this Helps,

Hirish

[sunny_talwar]

On similar lines:

=Dual(Pick(Match(cmplexity, 2, 4, 8), 'simple', 'expect', 'common'), cmplexity) as cmplexity

This avoid having two fields telling the same story

[Chanty4u]

thnx all...all r wrkng fyn...i used If cndition

[Chanty4u]

nice hirish