Calculated expression

[jadams123]

Hi:

Is there any way to do this:

I just want to be able to put a comment on the expression side. This is a pivot.

I want to put this on the expression side.

I tried to use pick/match put it didnt work.

Thanks,

J

[MK_QSL]

IF(DAY = '14.Fri' and Location_Description = 'Central','$465')

[vinieme12]

Try as below

=IF(DAY = '14.Fri' ,Pick(Match(Location_Description,'Central','West'),'$465','$500'))

[girirajsinh]

HI Joe

If I have understood your question right ? would following arrangement at script level solve your issue ?

temp_table:
LOAD * INLINE [
F1, F2, F3
14.Fri, central, 634
14.Fri, west, 466
14.Fri, east, 681
14.Fri
];


map_table:
mapping LOAD * Inline
[
input_F1, map_F2,
14.Fri-central,465
14.Fri-west, 500
14.Fri-east, 800

];

main_table:
LOAD
F1,
F2,
F3,
ApplyMap('map_table',F1&'-'&F2) as Comment
Resident temp_table;

DROP Table temp_table;

Then use the Comment field in Pivot table.