{"title":"Column Auto Type Cast","nodeType":"Manipulator","id":"*iQCmMxBEl2szprD5","factoryName":"org.knime.base.node.preproc.colautotypecast.ColumnAutoTypeCasterNodeFactory","factoryId":"org.knime.base.node.preproc.colautotypecast.ColumnAutoTypeCasterNodeFactory","path":["Manipulation","Column","Convert & Replace"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"<p>This node determines the most specific type in the configured string columns and changes the column types accordingly. The type order is to first check if the values are dates, then integer, long, double, and finally string. For dates a custom format can be specified.</p>\n        ","shortDescription":"Converts a column of type String to a Numeric or Date type, if and only if all entries could be converted.","keywords":[],"deprecated":false,"streamable":false,"tags":["Manipulation","Column","Convert & Replace"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAA3hpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNi1jMDY3IDc5LjE1Nzc0NywgMjAxNS8wMy8zMC0yMzo0MDo0MiAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wTU09Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9tbS8iIHhtbG5zOnN0UmVmPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvc1R5cGUvUmVzb3VyY2VSZWYjIiB4bWxuczp4bXA9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC8iIHhtcE1NOk9yaWdpbmFsRG9jdW1lbnRJRD0ieG1wLmRpZDowYjM2YWM5Ny01ZWJhLTQwZTctOTE4OS1iYmU4ZDdkMGYyNGUiIHhtcE1NOkRvY3VtZW50SUQ9InhtcC5kaWQ6ODRDQzA3MUYxODM0MTFFNTgxM0FFMEQwQTc0Qzg5QTIiIHhtcE1NOkluc3RhbmNlSUQ9InhtcC5paWQ6ODRDQzA3MUUxODM0MTFFNTgxM0FFMEQwQTc0Qzg5QTIiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIDIwMTUgKE1hY2ludG9zaCkiPiA8eG1wTU06RGVyaXZlZEZyb20gc3RSZWY6aW5zdGFuY2VJRD0ieG1wLmlpZDpjZTBmYzg4ZC1kNjkyLTQ5NDEtOTZiOC03ODIxMjliYWZkYWIiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6MGIzNmFjOTctNWViYS00MGU3LTkxODktYmJlOGQ3ZDBmMjRlIi8+IDwvcmRmOkRlc2NyaXB0aW9uPiA8L3JkZjpSREY+IDwveDp4bXBtZXRhPiA8P3hwYWNrZXQgZW5kPSJyIj8+NNRiiQAAAHlJREFUeNrskksKwCAMRBPoHQrtZfWwLXTTK0xVRCZ+2kW3BsSQDC8fVQDyx3QCRDLARZeO43xVpOhSPCeNYlv3m+AgnyEyBFTdoQNpAN0RKgAsGwbQFO918AbAB0BGgCUHfFhcEZ7X4fmpeSeqmnTxDqbzK4s8AgwAcC6OyqosY9YAAAAASUVORK5CYII=","views":[],"inPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Input","description":"Arbitrary input data."}],"outPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Type-casted columns","description":"Input data with type-casted columns."},{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Type information","description":"Information about the chosen type casting."}],"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":"Column filter","description":"Select the columns to consider for automatic type casting. Only string columns and columns with an unknown type are shown. The filter supports manual selection and wildcard/regex.","optional":false},{"name":"Choose a date&time format","description":"Choose or enter a date, time, or date&amp;time pattern used to detect dates in the selected columns. The used locale will be the system default. For further configurations use the <i>String to Date&amp;Time</i> node.\n<br />\nThe used parser depends on the setting <i>Use legacy date&amp;time type</i> . When checked, the <a href=\"https://docs.oracle.com/javase/8/docs/api/java/text/DateFormat.html\" rel=\"ugc nofollow noopener noreferrer\">DateFormat</a> is used, else the <a href=\"https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/time/format/DateTimeFormatter.html\" rel=\"ugc nofollow noopener noreferrer\">DateTimeFormatter</a> . The <i>DateFormat</i> might not support every placeholder specified below.\n<br />\n<b>Examples:</b>\n<ul><li>&#34;yyyy.MM.dd HH:mm:ss.SSS&#34; produces dates such as &#34;2001.07.04 12:08:56.000&#34;</li><li>&#34;yyyy-MM-dd&#39;T&#39;HH:mm:ss.SSSZ&#34; produces dates such as &#34;2001-07-04T12:08:56.235-0700&#34;</li><li>&#34;yyyy-MM-dd&#39;T&#39;HH:mm:ss.SSSXXX&#39;[&#39;VV&#39;]&#39;&#34; produces dates such as &#34;2001-07-04T12:08:56.235&#43;02:00[Europe/Berlin]&#34;</li></ul>\n<b>Supported placeholders in the pattern are:</b>\n<ul><li>G: era</li><li>u: year</li><li>y: year of era</li><li>D: day of year</li><li>M: month in year (context sensitive)</li><li>L: month in year (standalone form)</li><li>d: day of month</li><li>Q/q: quarter of year</li><li>Y: week based year (you probably want to use y instead)</li><li>w: week of week based year</li><li>W: week of month</li><li>E: day of week</li><li>e: localized day of week\n  <ul><li>e: 4</li><li>ee: 04</li><li>eee: Wed</li><li>eeee: Wednesday</li><li>eeeee: W</li></ul></li><li>c: day of week</li><li>F: day-of-week in month</li><li>a: am/pm of day</li><li>h: clock hour of am/pm (1-12)</li><li>K: hour of am/pm (0-11)</li><li>k: clock hour of am/pm (1-24)</li><li>H: hour of day (0-23)</li><li>m: minute of hour</li><li>s: second of minute</li><li>S: fraction of second</li><li>A: milli of day</li><li>n: nano of second</li><li>N: nano of day</li><li>V: time zone ID</li><li>z: time zone name</li><li>O: localized zone offset</li><li>x: zone offset (ISO8601)\n  <ul><li>X: &#43;08 or &#43;0830</li><li>XX: &#43;0800 or &#43;0830 (no colons)</li><li>XXX: &#43;08:00 or &#43;08:30 (with colons)</li><li>XXXX: &#43;0800 or &#43;083015 (i.e. including offset seconds, no colons)</li><li>XXXXX: &#43;08:00 or &#43;08:30:15 (i.e. including offset seconds, with colons)</li></ul></li><li>X: same as x, but outputs Z when offset is 0</li><li>Z: zone offset (RFC822)\n  <ul><li>Z, ZZ, ZZZ: &#43;0800 or &#43;0830</li><li>ZZZZ: GMT&#43;08:00 or GMT&#43;08:30</li><li>ZZZZZ: &#43;08:00 or &#43;08:30:15</li></ul></li><li>p: pad next</li><li>&#39; : escape for text</li><li>&#39;&#39;: single quote</li><li>[: optional section start</li><li>]: optional section end</li></ul>","optional":false},{"name":"Missing value pattern","description":"Enter a missing value pattern applied to all included columns. Two special strings which will not be treated as pattern exist:\n<ul><li><i>&lt;none&gt;</i> : no pattern (default)</li><li><i>&lt;empty&gt;</i> : for the empty string</li></ul>","optional":false},{"name":"Quickscan","description":"Speed up by determining the most specific type based only on the first N rows.\n<br />\nNote: With quickscan enabled this node may fail during execution if later rows contradict the inferred type.","optional":false},{"name":"Number of rows to consider","description":"Number of initial rows used when quickscan is enabled.","optional":false},{"name":"Use legacy type names instead of identifiers","description":"Output legacy type names like &#39;Number (double)&#39; on the second port instead of identifiers like &#39;org.knime.core.data.def.DoubleCell&#39;. This resembles the old behavior but is discouraged as type names may change in future versions.","optional":false},{"name":"Use legacy date&time type","description":"Output date with the legacy date and time type (org.knime.core.data.date.DateAndTimeCell) or the successor types (org.knime.core.data.time.*.LocalTimeCell/LocalDateCell/LocalDateTimeCell/ZonedDateTimeCell).","optional":false}]}],"links":[],"kudos":[],"kudosCount":0,"bundleInformation":{"bundleVersion":"5.12.0.v202606261225","bundleName":"KNIME Base Nodes","bundleSymbolicName":"org.knime.base","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":[{"id":"*ZgYyOm1P9VJVBE9e","factoryName":"org.knime.base.node.preproc.joiner.Joiner2NodeFactory","probability":0.06689734717416378},{"id":"*5stmXk6zY_ORA4bC","factoryName":"org.knime.base.node.preproc.groupby.GroupByNodeFactory","probability":0.04498269896193772},{"id":"*Oy714gpoifm4PiOZ","factoryName":"org.knime.base.node.io.csvwriter.CSVWriterNodeFactory","probability":0.04267589388696655},{"id":"*DOkyMaii62U05xZ1","factoryName":"org.knime.base.node.preproc.filter.column.DataColumnSpecFilterNodeFactory","probability":0.04152249134948097},{"id":"*5xTQbnNLONK0vecv","factoryName":"org.knime.base.node.io.database.DBWriterNodeFactory","probability":0.03344867358708189},{"id":"*20rIDLuYXD4U8cnN","factoryName":"org.knime.base.node.preproc.colconvert.stringtonumber.StringToNumberNodeFactory","probability":0.029988465974625143},{"id":"*2fI5rIsFDCFPHc0R","factoryName":"org.knime.ext.jep.JEPNodeFactory","probability":0.029988465974625143},{"id":"*jd2U-FYTI8jCbQls","factoryName":"org.knime.base.node.preproc.filter.row.RowFilterNodeFactory","probability":0.02883506343713956},{"id":"*PHWv6FsABEjrSc76","factoryName":"org.knime.base.node.preproc.rename.RenameNodeFactory","probability":0.02422145328719723},{"id":"*JiJhJpgkWWuOfG2s","factoryName":"org.knime.ext.poi2.node.write2.XLSWriter2NodeFactory","probability":0.02306805074971165}]}