Hello all, Below is my script for extended interval match and the expected output. its simple not working and I can't figure out why. Could you please help? Range: LOAD * INLINE [ Max r...
...owever, it takes me 2 joins. I've read in the help about the extendedintervalmatch functionality. But it doesn't deliver the expected results. To demonstrate, I've created a simple example. In this e...
I need to display sales transactions totals per individual sales team member.. I have a table containing a salesteam code (used for the sales transactions) and two different fields indicating the ...
I have a problem with the intervalmatchextended syntax, see attached file. it dosent get the tartildato correct when i connect both tables with an intervalmatch. Output in Q...
I'm creating an interval match in extended mode: Bridgetable: //left join (Facts) IntervalMatch (Datum, USER) LOAD Startdate, Enddate, USER Resident Employees; I do not get anything f...
I hope someone can help me with the command IntervalMatch. I have salesorders in currency, I want to convert then to EURO's. So I have a currency and a amount. Also I have the count rate per c...
I have a problem with the intervalmatchextended syntax, see attached file. it dosent get the tartildato correct when i connect both tables with an intervalmatch. seems like the problem is t...