Interval Match and Duplicate Values

[brindlogcool]

Hi,

I am trying to use the interval match and it is generating duplicate values.

While loading the script it is showing as 21 rows and if you see the preview in the Ctrl+T it is showing 31 rows... Attached theQVW file and screenshot for your reference.

[#2]

Just add a DISTINCT command... Like below..

AUTOGENERATE $(vMaxDate) - $(vMinDate) +1;

FullTable:

JOIN (Data) INTERVALMATCH (Date) LOAD DISTINCT DateStart, DateEnd

RESIDENT Data;

DROP TABLE Calendar;