Icon

kn_​forum_​27700_​spot_​rate_​previous_​month

Aggregate values from previous month and read the result back to current month

Aggregate values from previous month and read the result back to current month

Aggregate values from previous month and read the result back to current monthhttps://forum.knime.com/t/calculate-average-rates-by-previous-month/27700 sample_spot_rate.xlsxone month backcurrent_month_stampyyyymmlast_month_stampyyyymmGroup byCountryand Monthavg_rate_prev_monthresult.xlsx Excel Reader (XLS) Extract Date&TimeFields Date&Time Shift Extract Date&TimeFields Math Formula Math Formula GroupBy Column Rename Joiner Sorter Column Filter Excel SheetAppender (XLS) Aggregate values from previous month and read the result back to current monthhttps://forum.knime.com/t/calculate-average-rates-by-previous-month/27700 sample_spot_rate.xlsxone month backcurrent_month_stampyyyymmlast_month_stampyyyymmGroup byCountryand Monthavg_rate_prev_monthresult.xlsx Excel Reader (XLS) Extract Date&TimeFields Date&Time Shift Extract Date&TimeFields Math Formula Math Formula GroupBy Column Rename Joiner Sorter Column Filter Excel SheetAppender (XLS)

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: m_lauber
Created at: 2020-09-29
On NodePit since: 2020-09-29
Last update: 2024-04-27
Created with KNIME version: v4.2.1

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!