Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
IF(DAY = '14.Fri' and Location_Description = 'Central','$465')
Try as below
=IF(DAY = '14.Fri' ,Pick(Match(Location_Description,'Central','West'),'$465','$500'))
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.