I have economic data by year/month that I am preparing to join with other data by year/month/day/hour, so I would like to expand the economic data rows to impute the same economic data for the year/month to every year/month/day/hour of the other table
I did find “Create Date&Time Range” and was able to to create all of the days and hours in the days for the yyyy:MM ranges that I have filtered to. That’s as far as I’ve been able to get.
I have checked your flow and data but not sure how would your desired output look like. You want to have same data for each hour of the day or missing values or?
I would like to add rows to fill out every hour of the months within the range, then impute the economic data of that month to every hour of that month. So if a month had 3.9% unemployment, then every hour of every day for that month would have 3.9% unemployment. I went down the path of creating an empty datetime object with the datetimes in the range I’m looking for, though I don’t know if that is a deadend or not.
Here is my solution. Essentially for each date, create 24 rows then counter generation 0 through to 23 and then shift the time from 00:00:00 for each hour (counter generated). I’m sure there is a cleaner way of doing this though but I’ve not been around for a while and fancied a quick challenge
if I got it right I would extract year and month from both input data and Create Date&Time Range node followed by left outer join in Joiner (Labs) node. Take a look at attached example: EconomicDataImportPrep_ipazin.knwf (62.4 KB)
Additionally I suggest to keep (smaller) data within workflow folder and use workflow relative paths.