How to join 2 tables

Wed, 24 Feb 2016 12:13:51 GMT

Hi,

I have the below join situation in SQL Server and works fine.

However, how can I create the join in Bold with QV? I can create the #Raw and #Stats within QV and the common fields BusinessDateand & sUser will create the join I need but how can I create the third join r.id BETWEEN s.StartID AND s.FinishID

select * from #Raw R

LEFT join #Stats as S

on R.BusinessDate= S.BusinessDate

and R.sUser = S.sUser

AND r.id BETWEEN s.StartID AND s.FinishID

Maybe, I could load the data into another dataset within the Script but that leaves me with only 1 table effectively, I would like to have 2 and have the join between them.

Thanks very much for any answers.

Re: How to join 2 tables

hic — Wed, 24 Feb 2016 13:21:48 GMT

Use an IntervalMatch: See IntervalMatch

HIC

topic Re: How to join 2 tables in QlikView

How to join 2 tables

Re: How to join 2 tables