Visokio Forums

anna · January 30, 2012 7:08AM

Hello

I would like to merge two datasets where one contains daily data (multiple entries in one day), the other file is monthly (single entry each month). Could you advice on the most efficient way to do that?
My aim is to transform 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

indranildatta · January 31, 2012 5:34AM

Hi 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.

Cheers!
Indranil

Visokio Forums

Welcome!

Categories