Edit dimension in straight table

[narender123]

Hi All,

I am  editing a dimension under "straight table> dimension> edit" but not able to do it completely.

Like:

=if(cpcdesc='C4201','MANUFACTURING',

if(cpcdesc='C4301','Duty',

if(cpcdesc='C427','Hotels',

if(cpcdesc='C422','Goods' ))))

its working .

But its not working when use like this

=if(cpcdesc='C4201','MANUFACTURING',

if(cpcdesc='C4301','Duty',

if(cpcdesc='C427','Hotels',

if(cpcdesc='C422','Goods' ))),cpcdesc)

This type will work in script level but why not under straight table dimension?

Thanks,

Narender

[Anonymous]

try this, some misplacement are their:

=if(cpcdesc='C4201','MANUFACTURING',

if(cpcdesc='C4301','Duty',

if(cpcdesc='C427','Hotels',

if(cpcdesc='C422','Goods',cpcdesc))))

[its_anandrjs]

Try this one

=if(cpcdesc='C4201','MANUFACTURING',

if(cpcdesc='C4301','Duty',

if(cpcdesc='C427','Hotels',

if(cpcdesc='C422','Goods',

if(Not Match(cpcdesc,'C4201','C4301','C427','C422'),cpcdesc)))))

Regards,

Anand

[HirisH_V7]

Hi ,

IF you want to load field with n Number  of changes,You can use replace,

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

T:
REPLACE ONLY  LOAD * INLINE [
    Type
    1 
   2
   3
];

output:

Else This way,

=If(match (Value,'8'),'Common'

,If(match (Value,'4'),'Other'

,Value))

As your Caluculated Dimension,

Hope this helps,

Hirish