...pproved on behalf of Mr. Green. (Mr.Red is the delegator for a different time period)
I feel that intervalMatch should solve this but I am struggling to bring back the delegator name.
LOAD ID, A...
...bsp; IntervalMatch (matchfield,keyfield1 [ , keyfield2, ... keyfield5 ] ) (loadstatement | selectstatement ) further on it states: "When the IntervalMatch prefix is extended...
...opes that it will dramatically increase the load time and hopefully the amount of data I’m able to load. It seems the solution might be some combination of Extended Interval Match and Slowly Changing D...
Apologies if this isn't the right part of the forum, I am happy to be directed to the appropriate place! I have reviewed a lot of the information around canonical dates here in the Community (Canonic...
Hi Team,
Looking for the Script to pick nearest next Date from the list of dates. I have below example to show. in MM/DD/YYYY
Table A: Invoices with Due Dates
Invoice
Due date
123...
...he range table where there is an additional charge for extended region if the postal code falls within the Postal Code From and Postal Code To interval with Charge being the fee. [Extended...
there is one table as employee that has fields : emp id, terr id,joining date another table as sales history which has : emp id, terr id, start date, end date
employee Load*Inline [ empid, emp_n...
...0', '24/11/2017 15:59', 4 3, sara, '24/11/2017 16:00', '24/11/2017 23:59', 5 I need to know how much money is made during the shifts of every floor manager. I've tried to use IntervalMatch but I h...
