Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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) |
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