Challenge 36 - Implementing custom time alignment
KNIME has just released a new textbook on time series: to celebrate it, we will do a little time series analysis in this challenge. Check out the book (and discount!) here: https://www.knime.com/codeless-time-series-analysis-with-knime
For this challenge you will perform time alignment on data that contains two types of gaps: regular gaps by the nature of the data, and irregular gaps. For example, daily stock market data regularly skips Saturdays and Sundays, and irregularly skips some other weekdays due to public holidays. Your concrete task for this challenge is to introduce the missing timestamps that correspond to weekdays into the given data, while omitting those for weekends. The data contains the daily exchange rates of US dollar vs Swiss franc from 1980 to 1998. Hint: Check out our verified components for time series analysis. Hint 2: For reference, if you get access to the book, check out Chapter 3 (Preparing Data for Time Series Analysis) which this challenge is based on.
Nodes
- Column Rename (Regex)4 ×
- Create Date&Time Range4 ×
- End IF4 ×
- Rule Engine Variable4 ×
Table Row to Variable4 ×- CASE Switch Variable (Start)2 ×
- Java Edit Variable2 ×
- Joiner2 ×
- Merge Variables2 ×
- Row Filter2 ×
- Sorter2 ×
- Boolean Configuration1 ×
- CSV Reader1 ×
- Column Filter1 ×
- Column Selection Configuration1 ×
- Domain Calculator1 ×
- Date&Time Part Extractor1 ×
- Extract Table Dimension1 ×
- Extract Table Spec1 ×
- Group Loop Start1 ×
- IF Switch1 ×
- Loop End1 ×
- RowID1 ×
- Single Selection Configuration1 ×
- String to Date&Time1 ×
Extensions
Links
- No links available