This workflow demonstrates the usage of flow variables in the date and time nodes. Here the use case is to filter the last full week of data. Hence if you execute the workflow on wednesday you still only want to get the data until the last saturday.
We achieve this by first finding the last Sunday. This will be the enddate in our filter node.
Afterwards we use the information as a flow variable in the Date&Time-based Row Filter node. In addition we set the end of the filter to one week before the start date.
EXAMPLES Server: 02_ETL_Data_Manipulation/06_Date_and_Time_Manipulation/04_Filter_TimeSeries_Data_Using_FlowVariables02_ETL_Data_Manipulation/06_Date_and_Time_Manipulation/04_Filter_TimeSeries_Data_Using_FlowVariables*
Download a zip-archive
* Find more about the Examples Server here.
The link will open the workflow directly in KNIME Analytics Platform (requirements: Windows; KNIME Analytics Platform must be installed with the Installer version 3.2.0 or higher). In other cases, please use the link to a zip-archive or open the provided path manually