Hello - I would like to merge two datasets where one contains daily data (multiple entries in one day), whereas the other file is monthly (single entry each month). Could you advise on the most efficient way to do that? My aim is to transform the daily file into monthly values. I'm planning to use the formula referring to the entries from both files so it's important to obtain the same data frequency beforehand. I would appreciate your help. Thanks Anna
For the benefit of other forum users, here's what we discussed on this issue. For time series data with date/time fields in different granularity, we need to use the Aggregate operation in DataManager to bring both the datasets to the same level. When you aggregate based on a date/time field, explore the options Histogram and Fixed interval size. Using these you'd be able to aggregate on daily, weekly, monthly, quarterly etc.