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