This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I'm trying to implement a simple JOIN of two tables on a date range.
Here is the scenario:
i) Transactions table got transactions for every day. Date + Product + Quantity 2014-01-01 PRODUCT1 100 2014-06-01 PRODUCT1 150 ii) Reference table got Product's multiplication factor for different date ranges:
I just thought of another way. You could try the insert rows tool on your reference table and include a row for every single date in the range. Product and multiplier would repeat. Then join on product and date.
@FDELABAL If this result is really desired, then you can open the Macro and go to the Join Multiple Tool(s) and change the "Cartesian Joins" option to "Allow All multidemensional Joins". However, be careful with this as your temp drive may fill up quickly. Make sure either your Temp folder either doesn't reside on the OS drive or watch the process closely to make sure that you don't crash your system.