Hi all,
It would be great to hear from anyone who can advise how to overcome a challenge I'm facing when connecting data based on specific dates to another dataset which does not necessarily have the same precise dates (hence need to find closest match).
I'm trying to identify the Price relating to a list of multiple Codes on specific Dates. I need to locate the Date and Code combination from the first data source within the secondary dataset which contains the desired Prices at various dates. As mentioned however, the exact date from my query may not exist in the secondary (Price Data) source therefore I have to find the Price at the closest point in time for that Date and Code combination.
2 Data sources (per Text Input tools in attached):
(1) List of codes and dates for which I need to identify the relevant price value
(2) Price Data Source - list of prices at various dates
Additional comments:
Ideally the 'closest point in time' should by identified as either before or after the Request Date (whichever is really closer) - but if easier I can work with the logic being to choose e.g. just the 'previous' date which exists in the Price Data source.
Many thanks for any advice provided. And feel free to direct me to other similar topic threads.
