Icon

Fix missing dates

Interpolate missing dates using unix timestamps and missing values

sample datawith some missingdatestakbb componentGenerate "unix seconds"columnlinear interpolationunix secondsback to newdate columnConvert Serial Secondsto Long datatypetime diffsince 1970-01-01multiply by -1linear interpolationunix secondsback to newdate columnConvert Serial Secondsto Long datatypeTable Creator Date&Time toSerialNumber Missing Value UNIX Timestampto Date&Time Double To Int Date&TimeDifference Math Formula Missing Value UNIX Timestampto Date&Time Double To Int sample datawith some missingdatestakbb componentGenerate "unix seconds"columnlinear interpolationunix secondsback to newdate columnConvert Serial Secondsto Long datatypetime diffsince 1970-01-01multiply by -1linear interpolationunix secondsback to newdate columnConvert Serial Secondsto Long datatypeTable Creator Date&Time toSerialNumber Missing Value UNIX Timestampto Date&Time Double To Int Date&TimeDifference Math Formula Missing Value UNIX Timestampto Date&Time Double To Int

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: bbate
Created at: 2024-04-01
On NodePit since: 2024-04-01
Last update: 2024-05-01
Created with KNIME version: v4.7.8

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

Try NodePit Runner!