Time Match Interval Duplication

[#1]

I am trying to get Zone and Percentage for a specific Device and time. That is I am matching Interval Device and Time with Time Interval to get its Zone and Percentage. The Device can be connected to multiple devices with percentage allocated. But it is working fine with single row but as soon as there are x-squared lines to one interval there is x duplication of lines in end result. For example I have made 3 Zones for a specific interval so there are 9 lines instead of 3 lines.

Can anyone help to eliminate the extra rows or alternate solution

[#2]

Hi Aamir,

I'm facing the same problem if anyone have idea please share.

[#3]

Adeel

swuehl

Gysbert Wassenaar

Guys please reply

[whiteline]

Load distinct

[#5]

where should i use distinct. I mean in which load as I can't use it interval match

[whiteline]

You have to prepare the table before using interval match.

Create temporary table with load distinct.

[#7]

Can you do this in my QVW because i don't think that's right solution as multiple lines are required in temp table of Interval match

[#8 · Accepted solution]

Aamir,

Please find attached file hope this will help