Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Filling a sequence - using 1st and last entry

Hi Qlikheads,

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:

   

TSTAMPDESTINATIONSERIALNOLASTINRANGE
Sep/139372910002071588910002271587
Sep/137629920001711543920001711562
Oct/135591960000062807960000072806
Oct/137890900000967163900001087162

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.

Any help will be greatly appreciated.

3 Replies
miguelbraga
Partner - Specialist III
Partner - Specialist III

Hey there,

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...

Regards,

MB

Kushal_Chawda

You can do something like below

Data:

LOAD

TSTAMP,

DESTINATION,

SERIALNO,

LASTINRANGE,

SERIALNO+iterno()-1 as FILLED_SERIAL

FROM table

while SERIALNO+iterno()-1 <= LASTINRANGE;

Note : There will be a performance impact if the Data is huge.

ziadm
Specialist
Specialist

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

Thanks