Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
like this?
if(Complexity=2, 'Simple',
if(Complexity=4, 'Expect',
if(Complexity=8, 'Common'))) as NewField
May be this:
Pick(Match(cmplexity, 2, 4, 8), 'simple', 'expect', 'common')
like this?
if(Complexity=2, 'Simple',
if(Complexity=4, 'Expect',
if(Complexity=8, 'Common'))) as NewField
=Pick(Match(cmplexity,'2', '4','8'), 'simple', 'expect', 'common') as Complexity_new
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
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
thnx all...all r wrkng fyn...i used If cndition
nice hirish