Load script, mapping to allocate sales sector based on post code range
I have two tables, one containing sales per postcode and another containing sector ranges allocated to salespeople :
In my load script, I would like to add the sector to SALES table based on the range to which is linked the sales ZIP code (and country code also). A simple join will not work for sure. So I was thinking about mapping the ZIP_2_SECTOR table to use it in the load statement of my SALES table. I don't think it will work neither.
Any tip, suggestion on the best way to go would be helpful.
If this answers your question or solves your issue, be sure to mark the answer as correct by clicking 'Accept as Solution'. This will mark the post as solved and other Qlikkies will gravitate towards this post as it as a possible solution for their issue. Multiple responses can be accepted as a solution so make sure to select all that apply.
Glad you found the solution that works. I think it is great for the requirements you specified. I did not know all the requirements and hence this is good. It all depends which match you want to make and which fields you want to keep. You could keep the ZIP_2_ZONE table if the users also need these dimensions (to know which countries are also in the data), but from the information I got you did not need it.