topic Linking two tables in QlikView

Linking two tables

Thu, 18 Sep 2014 10:59:36 GMT

Hi,

I have two tables in my application. Table 1 has following fields:

[Start Time] [End Time] [Details]

09/18/2014 18:00 09/18/2014 18:30 DNM

Table 2 has following fields:

[Time of Action] [Other Details]

09/18/2014 18:14 DNC1

09/18/2014 18:20 DNC2

I want to create a master table such that if the [Time Action] is between the [Start Time] and [End Time], I append all the details. The final table which I want is similar to this:

[Start Time] [End Time] [Details] [Time of Action] [Other Details]

09/18/2014 18:00 09/18/2014 18:30 DNM 09/18/2014 18:14 DNC1

09/18/2014 18:00 09/18/2014 18:30 DNM 09/18/2014 18:14 DNC2

Is this possible?

Re: Linking two tables

vikasmahajan — Thu, 18 Sep 2014 11:01:04 GMT

You need to apply Interval Match command we have lot of example in community for interval match search

and use it.

Vikas

Re: Linking two tables

Gysbert_Wassenaar — Thu, 18 Sep 2014 11:10:49 GMT

You can use the intervalmatch function. See this blog post for an example: IntervalMatch

Re: Linking two tables

Thu, 18 Sep 2014 15:36:04 GMT

Thanks Gysbert - however, as I was reading about Interval Match i realized that there is an additional challenge.

There is an ID column in both the tables and I need to ensure that the ID's are same while linking the two tables. Is there a way to implement this?

Once again, thanks a lot for your help.

Re: Linking two tables

Gysbert_Wassenaar — Fri, 19 Sep 2014 09:38:22 GMT

Exactly for that purpose the IntervalMatch function has an extended syntax. You can pass the ID as extra parameter. See this discussion for an example: Between / subquery /intervalmatch(?) issue

Re: Linking two tables

amit_saini — Fri, 19 Sep 2014 09:40:35 GMT

Balaji,

Hope this will help you.

Thanks,
AS