Creating Buckets (on size and selling price)

[israrkhan]

Hi Guys,

i have to create bucket for product sold, and product size,

i have a product table, product table is linked to Model Table, and Model table linked to Transaction table. in the transaction table i have my quantity and selling price.

i have defined the buckets range in the below excel file. the product column in the below excel is linked to my Product column in product table. i dont have product column in the transaction table, so how to do it.

kindly help me, how to achieve this, in the load script or front end.. idea please..

i would appreciate your help.

Bucket Table:

Prodcut:	Indicator	Minimum	Maximum	Label
TV	SIZE	0	26	26" ↓
TV	SIZE	26	32	32"
TV	SIZE	32	38	37"
TV	SIZE	38	43	40" - 42"
TV	SIZE	43	52	46" - 50"
TV	SIZE	52	58	55"
TV	SIZE	58	999	60"↑
Mobile	Price	0	75	ULC (<$75)
Mobile	Price	75	150	Low ($75-$150)
Mobile	Price	150	300	Mid ($150-$300)
Mobile	Price	300	500	High($300-$500)
Mobile	Price	500	600	Super High($500-$600)
Mobile	Price	600	9999	Ultra High($600 and above)
Tablets	Price	0	100	ULC (<$100)
Tablets	Price	100	200	Low ($100-$200)
Tablets	Price	200	300	Mid ($200-$300)
Tablets	Price	300	400	High($300-$400)
Tablets	Price	400	500	Super High($400-$500)
Tablets	Price	500	9999	Ultra High($500 and above)

[israrkhan]

1) in transaction table i don't have product, i have Model, because the transactions are on Model Level.

again my tables are linked

Bucket table linked to Product Table through Product Column in Product Table, and Product B column in Bucket table.

Product Table linked to Model Table, both table have Product Code column..

Model Table linked to Transaction table through Model Code column..

Bucket >>-->> Product >>-->> Model >>-->> Trsanction

Many Thanks