grouping customers using an input file

Question

Hi

I want to group my customers based on size and segment. For example if a customer is in segment X, and has the size of 18, then it should be in customer group 15-20.

I have around 400 combinations of such groupings and it is really difficult to do it using the formula option.

I was thinking of using an input file to get the customer grouping. Basically it would say if the customer segment is X, and it lies between the min and max of the group banding then return me the grouping of that row.

SegmentMinimum size of groupMaximum size of groupGroupingX152015-20

Y101510-15

X212521-25

Thanks in advance for the help.

LordNeilLord · Accepted Answer

Hey @Himanshu123

I'd use the generate rows tool to expand your grouping, so you have a value for every point in the range. Then you can easily join this back to your customer data:

Himanshu123 · Accepted Answer

Thanks. It was simpler than I thought. Works like a charm.

BenMoss · Accepted Answer

Hi!

You need to scaffold your data.

Use a summarize tool to create a list of all year's in your dataset and append this to the records that fall out the left side of your join, then union this back to your J records.

Ben