How to create a Column at scripting

[kunkumnaveen]

Hello All,

I am Trying something like below ,it is Possible to create a column with values CV,PV,ALL.

if(segment='COMMERCIAL','CV',
if(segment='PERSONAL','PV',
if(segment='COMMERCIAL' and segment='PERSONAL','ALL')

)) as SEGMENT

I know if we select both CV and PV which is nothing but ALL, ..but User specifically  need  CV,PV,ALL 

Thanks

[agigliotti]

i think your expression below doesn't makes sense.

if(segment='COMMERCIAL' and segment='PERSONAL','ALL')

what does it means?

what are you trying to achieve?

[kunkumnaveen]

In a sample way, I have a Column Segment which has values COMMERCIAL,PERSONAL   

Now what i am trying to create a derived column with name SEGMENT which should suppose to have  CV,PV,ALL values

Which means

COMMERCIAL => 'CV',

PERSONAL  => 'PV'.

COMMERCIAL+PERSONAL=>ALL

How to achieve this requirement  

[kunkumnaveen]

Hi All,

Is my above requirement is feasible or Not 

[agigliotti · Accepted solution]

You could do this:

...
if( segment='COMMERCIAL', 'CV',
if( segment='PERSONAL', 'PV'
)) as SEGMENT;
...

New_Table:
LOAD * INLINE [
NEW_FIELD, SEGMENT
PV, PV
CV, CV
ALL, PV
ALL, CV
];

and use NEW_FIELD as your filter in UI.

[kunkumnaveen]

Hi,

Its worked , thanks for your suggestion.....