Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone!
I'm trying to understand logic behind Intervalmatch function, so its clear when we try to apply it having only two fields (start date, end date).
In my example i'm trying to apply intervals (join Value field to Main table) not only using Start & End date, but other fields (Company = Company Map, Account = Account Map).
Could anyone please explain how to play around this case? Thanks in advance!
Test qvw with example you can find in attachment.
Perhaps this discussion helps: Re: IntervalMatch Multiplying Records
Perhaps this discussion helps: Re: IntervalMatch Multiplying Records
Thanks a lot, Gysbert!
Tested your example and in my case Date for Company 1 and Account 1 isn't related to any appropriate date range (Start & End), so should be empty...