{"title":"Time Shifter","nodeType":"Manipulator","id":"*_lj-MFghefR5Hig6","factoryName":"org.knime.time.node.manipulate.datetimeshift.TimeShiftNodeFactory","factoryId":"org.knime.time.node.manipulate.datetimeshift.TimeShiftNodeFactory","path":["Other Data Types","Time Series","Manipulate"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"<p>Shifts time columns by a defined duration or granularity. You can select the time columns to shift and specify the shift value as a duration column, a numerical column with a granularity, or a constant numerical value with a granularity. Positive values shift forward; negative values shift backward.\n <br />\n Commonly used to adjust times for time zone corrections or shift schedules.</p>\n        ","shortDescription":"Shifts a time by a duration or granularity.","keywords":["modify","shift","date","time","hour","minute","second","millisecond","nanosecond"],"deprecated":false,"streamable":true,"tags":["Other Data Types","Time Series","Manipulate","Streamable"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAwCAYAAABXAvmHAAAACXBIWXMAACE4AAAhOAFFljFgAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAbFSURBVHgB7VlNbBNHFH5jO1UODnLLJSh/i5RwxUaKFEITNjeghySCkiNOuSLxI1UFBYlEatU/qRCJqu0hJBxDoTGV+DthEnACSLV7a5tILCY0ljjUCjlESbzT98br9e5613/rHKrySWvPjHdn35v3zZv3ngHe4R3e4T8NBlVAamoKgtd7EJu7gfM2YEzCdkD7OY39NI4r2E6Aqv6uLC9HYZtQtgJSc7MMHs8ANk9AXthyQQpF8Lpea2VKKiAEZ+wSXjLUBgpeo0oyeR1qAEcFpMZGCerqJh0ET+MVAaII5y+RToo2RgjA1lYArbUX2yG8iGqSzRwKZDKDyuvXCXABWwWk1tbT+DUKZqpkhVbVimkgSVIQnzsD9sqQNcagShQogMJfxq8zluFxXNFRRVHS4AKoiISKhLFJC2RcnARsbAwqqZQCFcKkgNTS8tBCmQQKPoyCuzKzFZoio5B1CDkoqERfpUp4TD3GHhl6tOp9tRaeoBCSyTA2jdSR4L33Hoq9VwHsKDQqXpJMjkIZkGU5AOvrWTrU16ej0WhFNEOrh3HhJg1DCVhd7VPS6bLmqfggk7s7gyrU9XPGZcYhCIVnQpozSDAVIhuc315YWFBKzVmgBOdXlFevzkIZKFsB+cMuOcPZJRRahgqAykTx48pcLHa72H1oeXIcl/UBVe0rx9uVVEDu6pIyXjbpJLjf7wd/Q4Nop1ZWHOfhwKY2VXWsmEWktrYZXP0BrasglUKlqFRUAVp1VWUzYKFJMLQPDh85gt8haNy1y/QMKbG0tAhzs7Nw/+5d65TK1ubWYOz5c1vHgM4pgCv/wvC+sVJ70VGB3gMHTgBXp4xjHx8/DuFPTuorXgqkzOS1iUJFmCc8++SJbShhoVIarbC7mBVsFeju7Az66nzxXL+xsREuXLwoVr4aLC0uwsj5zyCVSuljqsr7Hi8sRMFeCbKCpHXPohWuOM3tsQ4Q530+3wwYhB+/+n3VwhPaOzrEHDSX/mIPm+nCdzk8krcOY/1QBAUKqAxjIJbVPie8ledGpFIrkIjHxUVtJ9AcFiUCdWb/b5DKk19xzmUpEHAM373Gjrx//wBn7Mtcn17Y2tYGxfDz9A346ovPBc/9/gYI7XO2FO2djj0d+p5guFAtTc2PksvLivE+pPx6YMcOWUuUAE/oP9Orq7Yb32SBjEcEWQKH0MuQ6WsNouKxoSG9zyjXsANjtw3toNN8vlyDuK8afP0wepvtAs19c3oasrLR4d4Z/PvNG9rZA/pNjO1F+uR6/bixrZ7oBSVFugIZxgeY5pRo9Yvx3i3o8KMzhPYNwVfnJcGJ9xSdSmIwLzxoY1ZLhekjTyGPR9/tPb29sN04dOQjvc05OyhyDVUdLvNxJZeS6gpogZlAe3vtuW9FKBTS20gj8W4R+3AeLfkw53qgJxQQIbEhXNhO+hjfQVTSENBkQL/oLRWFTmGkGsl1shbIxfPgTvhE/LeiZ4EVxpBkXZNBS6DGHR/yeEz5swdcwt+gr6LYlENHj8LkxAS4AubfkK9yGDFGyZzpVvGJmVRuYO3tW6gEh3EzktcyYgoDuKFjR+FeYTRqgjH8rjfIoBUPrJUKBRWbss6hB3O93fv/AW0fTN+8VTGVlhb/woDtvClgI2RDiKsYQljCbqQaWUtDejY2/751TktQF7YrhukUQrerH9XxeBwqRXvHHpi+9QtcGBkxBW1ilXnh/YsYoebfze0LB3m3qjhV8vJulHG9InH/7h2oFuTfKYYaPpk9yenUtbPmY0x48mC26abuVrE6Ag7QKdTd3R30AdeX/s6DByI4cwNafWPKqY+b6QMbKt/tlGpSllasoKZbIBaLJZBG0Vx/cuIauIXw9TbZm9FLIX2ixfLkUtVAkxvFyfSdf/PGtB6r1BKUL5tTTDYOLmDKBygub21ukZmW0JACFBe5pVIORJ1Pz52DtbU10adKxdz8/NfgAgUHmZdz2vnCbMTh06dOVXS6OoHmEHPlfb9CZRZwCa91AHd+GrOkp5hohKlPq/V4bg6Dr33wwc6dUA3IkiMXzpsOLiyv9M0/e/YHuITXblBQqan5JSohEgxS4tdIRKwipYTlUmpt7S389MOP8N233+i0IXDgw0+ePrsPNUDRwpYor1CFgpn/lKDQoaenF9pRmYITdiWb5N/Ds8TGCaSxnDLoVE6pBmWVFrOVCnbC6Z7cQUWr7BRLkbvc5DBcTrG3EpRd3O3BigV+naYcFioACY7ny1gtV92IysvrwiKsH8ObAS2TKiyvY2yDvz3a2sxEnOqgtUJVf3QbQZlULhmpr+IPjv89/gVF7OGihjuX/AAAAABJRU5ErkJggg==","views":[],"inPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Input table","description":"Input table containing date&amp;time columns."}],"outPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Output table","description":"Output table with shifted time."}],"dynInPorts":[],"dynOutPorts":[],"additionalSiteInformation":{"url":"https://update.knime.com/analytics-platform/5.12","trusted":true,"enabledByDefault":true,"name":"KNIME Analytics Platform 5.12 Update Site","version":"5.12.0"},"dialog":[{"sectionName":"Options","fields":[{"name":"Date&time columns","description":"The date&amp;time columns whose values are shifted.","optional":false},{"name":"Shift mode","description":"Select the shift mode to use.\n<ul><li><b>Shift value</b> : Uses a time-based shift value.</li><li><b>Duration column</b> : Uses a shift value from a time-based duration column.</li><li><b>Number column</b> : Uses a numerical column to scale a configurable time unit.</li></ul>","optional":false},{"name":"Shift value","description":"Select to insert a format string to use as constant shift value. The inserted string can be either in:\n<ul><li>the ISO-8601 representation (see <a href=\"https://docs.oracle.com/javase/8/docs/api/java/time/Duration.html#parse-java.lang.CharSequence-\" rel=\"ugc nofollow noopener noreferrer\"> time-based duration format</a> for details)</li><li>the short letter representation (e.g. &#39;4H 5m 6s&#39;). In this case, the letters H, m, and s respectively indicate hours, minutes, and seconds.</li><li>the long word representation (e.g. &#39;4 hours 5 minutes 6 seconds).</li></ul>","optional":false},{"name":"Column","description":"Select to choose the shift value from a time-based duration column.","optional":false},{"name":"Column","description":"Select to choose the shift value from a numerical column. The shift value will be scaled by the selected granularity.","optional":false},{"name":"Granularity","description":"The granularity (i.e. hours, seconds, etc) of the shift.","optional":false},{"name":"Output columns","description":"Depending on this setting, the output columns will either replace the modified columns, or be appended to the table with a suffix.\n<ul><li><b>Replace</b> : Replaces the selected columns by the new columns.</li><li><b>Append with suffix</b> : Appends the selected columns to the input table with a new name that is the previous name plus the provided suffix.</li></ul>","optional":false},{"name":"Output column suffix","description":"The suffix to append to the column names of the new columns.","optional":false}]}],"links":[],"kudos":[],"kudosCount":0,"bundleInformation":{"bundleVersion":"5.12.0.v202606171548","bundleName":"KNIME Date and Time Handling","bundleSymbolicName":"org.knime.time","bundleVendor":"KNIME AG, Zurich, Switzerland","featureSymbolicName":"org.knime.features.base","featureName":"KNIME Base nodes","featureVersion":"5.12.0.v202606261225","featureVendor":"KNIME AG, Zurich, Switzerland","extensionId":"*bjR3r1yWOznPIEXS"},"frequentSuccessors":[]}