Mapping an expression to an external table.

[#1]

Hi folks,

Is it in anyways possible to map a calculated expression to an external table?

For e.g., what am trying to do is, after calculating the no. of days a user has used a service, for instance 64 days to map that particular output to a table where an ActiveMonths_GROUPING column which has a description that the particular user has been actively using the services lies in a particular group known as the 1-3 Months Active group.

I know I kinda suck at explaining the situation am in right now, but do bare with me here.

Thanks in advance.

Best Regards,

R

[swuehl]

You can look into a mapping approach, see here for a similar show case:

creating an age group from a date field

[#3]

I think your case may be similiar to this:

pick rating on the fly using calculated score

regards

Darek

[#4]

Thanks, will look into it. Much appreciated.

[#5]

Thanks, will look into it. Much appreciated.