determine the right division for each request in script

Fri, 06 May 2011 06:54:36 GMT

Hi,

I'm trying to determine for which division the request is made. (inline example in attachment)

|______________|_______________|__________________|______________|____________|____________|
START_TS REQUEST_TS 1 TRANSFER_TS 1 REQUEST_TS 2 TRANSFER_TS 2 REQUEST_TS 3 END_TS

So if the request is made between start and transfer1 (REQUEST_TS 1) it has the startDivision ( CB1 ),
if it's between Transfer 1 and 2 (REQUEST_TS 2) it's the division in the transfertable for the first transfer (CB 5).
if it's between Transfer 2 and the END (REQUEST_TS 3) it's the division in transfertable for the second transfer( back to CB1).

It's also possible there are no transfer then it's the startDivision.

How do i create a table with these tables were i can give each request a correct division and will it be possible to do this on
big files?

Pls help thx

topic determine the right division for each request in script in QlikView

determine the right division for each request in script