Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
try this, some misplacement are their:
=if(cpcdesc='C4201','MANUFACTURING',
if(cpcdesc='C4301','Duty',
if(cpcdesc='C427','Hotels',
if(cpcdesc='C422','Goods',cpcdesc))))
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
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