I am currently trying to recon 3 years worth of sales. I have already imported all sales by serial number into a qlikview document, but now I need to see where each serial number was shipped to. The shipments file I have received has the first and last serial number of each shipment, but not the middle values.
The data is in an excel file and looks like this:
What i need to do is match the serial number to the correct shipment so that I can return the destination for each serial number.
Can you please put a sample of your current data and your desired data so that we can provide a solution? With your given input in the question I can't develop a solution for you. Can you please explain better your issue with screenshots, photos form designs in paper, word documents, etc...
If you do not have a pattern in creating the serial no you will not be able to create the numbers. if you do have a pattern having the first and last digit please explain how this pattern can be developed