Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Inline:
Users, Year, Min, Max
List:
Numbers, Year2
INNER JOIN (Inline)
//intermatch:
INTERVALMATCH (Numbers, Year2)
LOAD DISTINCT Min,Max, Year as Year2
RESIDENT Inline;
DROP TABLE List;
the intervalmatch self is fine .. but the years is not picked up for some reason. This is the correct syntax right?
I would guess that you need a inner join (List), but I don't really got what you want to do.
Maybe you could post a more complete script snippet with some sample data and describe what the expected result should look like?
is was a year mismatch problem. I have put a NUM before each year, and it worked.
Thanks for your reply