Query limiting values by 'valid from'

Tue, 11 Oct 2011 10:08:04 GMT

Hi,

this is what I would like to realise:

Query limiting values for a dataset depending on the time range when these are valid.

Examplel:

Table A (Data):

Name Date Value

System1 01.10.2011 91

System1 02.10.2011 92

System1 03.10.2011 91,5

System1 04.10.2011 93

Table A (Limiting values):

Name Date_B Value_B

System1 01.10.2011 90

System1 03.10.2011 95

Expected result:

Table C (results):

Name Date Value Value_B

System1 01.10.2011 91 90

System1 03.10.2011 91,5 95

System1 04.10.2011 93 95

Thank's for your help.

Re: Query limiting values by 'valid from'

lironbaram — Tue, 11 Oct 2011 11:04:44 GMT

hei

attach is an example

the logic is in the load script to connect evry record to the correct value_b

this i achive using interval match

hope it helps you