¿How to delete or update records taking into account a relative date range?

Hi all, I am new to using Knime to organize my data streams. In this case, I have a set of sales records that travel to another database from which I create my BI dashboards, however due to the dynamics of my commerce I need to update the data in a range of 15 days before with respect to the current day. On a daily basis I need my flow to delete and re-save the records in that relative time period.

Could you help me to find a solution?

image

Here’s a way to handle the date range. I know nothing about manipulating your databases so you’ll have to figure out the overwriting/deleting/appending/resaving.
1a
2




1 Like

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.