{"title":"Extract Table Spec","nodeType":"Other","id":"*MD6juzhoWJLJGkE9","factoryName":"org.knime.base.node.util.extracttablespec.ExtractTableSpecNodeFactory","factoryId":"org.knime.base.node.util.extracttablespec.ExtractTableSpecNodeFactory","path":["Manipulation","Table"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"<p>Node extracting the meta information from the input table (column names, types, etc.) The meta information is referred to as the table data specification and contains information such as column names, types, domain values (list of possible values for categorical columns) and lower and upper bounds. It also contains the information which of the columns have a view handler associated (optional operation). Each column in the input table is represented as a row in the output. This node can be used in conjunction with the Insert Column Header node, where the column names are extracted from the input table, then modified in the workflow and later merged back into the main table.</p>\n        ","shortDescription":"Node extracting the meta information from the input table (column names, types, etc.).","keywords":[],"deprecated":false,"streamable":false,"tags":["Manipulation","Table"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAA3BpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNi1jMDY3IDc5LjE1Nzc0NywgMjAxNS8wMy8zMC0yMzo0MDo0MiAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wTU09Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9tbS8iIHhtbG5zOnN0UmVmPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvc1R5cGUvUmVzb3VyY2VSZWYjIiB4bWxuczp4bXA9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC8iIHhtcE1NOk9yaWdpbmFsRG9jdW1lbnRJRD0ieG1wLmRpZDowYjM2YWM5Ny01ZWJhLTQwZTctOTE4OS1iYmU4ZDdkMGYyNGUiIHhtcE1NOkRvY3VtZW50SUQ9InhtcC5kaWQ6RTBDNjU3NDA4QTIwMTFFNTkyQzJBQjlCNTFCMUUyMzIiIHhtcE1NOkluc3RhbmNlSUQ9InhtcC5paWQ6RTBDNjU3M0Y4QTIwMTFFNTkyQzJBQjlCNTFCMUUyMzIiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIDIwMTUgKE1hY2ludG9zaCkiPiA8eG1wTU06RGVyaXZlZEZyb20gc3RSZWY6aW5zdGFuY2VJRD0ieG1wLmlpZDpBMUY4MkM3QzQ1QzYxMUU1QUM2QkE3NzQyQjhFM0EyRCIgc3RSZWY6ZG9jdW1lbnRJRD0ieG1wLmRpZDpBMUY4MkM3RDQ1QzYxMUU1QUM2QkE3NzQyQjhFM0EyRCIvPiA8L3JkZjpEZXNjcmlwdGlvbj4gPC9yZGY6UkRGPiA8L3g6eG1wbWV0YT4gPD94cGFja2V0IGVuZD0iciI/Pgw+hDkAAADTSURBVHjapFKxEcIwDJR8Ln2HO/dZgZJ96KhZgZ6KWagZgxXgmEBYxiKyLgQH/k6Jokiy/i0EAIJ5oA0QjSX+cdwUZ7W7gPgCjkkBItJUMwfLQPr03gZUT3/xUb7w+6qBosAjNDS8jJQTwI7HMTM/2rwlGjjbsEzQodq0ejpHLMZIIQRKKRUzdXuVe842lH9UAaNLJsbFg/j1mx8n9j38Bmw2o2MCxkHTZUpvfeZMaycUauzGb6cCTYIRfSsLp67y/g+Fa7Z12VDJ+LSJdnUtngIMAE2n6DLT1/mNAAAAAElFTkSuQmCC","views":[],"inPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Table to extract spec.","description":"The input table to extract the psec from."}],"outPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Table containing spec information","description":"The output table containing the spec information of the input table."}],"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":"Extract property handlers","description":"If checked the information which of the columns have property handlers e.g. color handler associated is extracted, otherwise not.","optional":false},{"name":"Possible values as collection","description":"If checked, the possible values of each columns are extracted as possible values, otherwise not.","optional":false},{"name":"Format of Type Names","description":"Determines how the types of columns are represented in the output table.\n<ul><li><b>Identifier</b> : The type names are represented with a unique identifier. This is the recommended option.</li><li><b>Legacy Display Name</b> : The type names are represented by their old display name. This option is intended to be used purely for backwards-compatibility for workflows created in version 5.4 or before.</li><li><b>Display Name</b> : The type names are represented by their display name. This name may change at any point with an update, so it is highly discouraged to match against this output in any way.</li></ul>","optional":false}]}],"links":[],"kudos":[{"accountId":"account:user:751e2226-1074-4bf6-b7af-29a0c091d977","user":"gimbo","date":"2021-02-22T14:12:53+00:00"},{"accountId":"account:user:552210dd-3dfc-4b47-bbe6-477d972e6b9e","user":"nilotpalc","date":"2022-09-19T17:22:26+00:00"}],"kudosCount":2,"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.08685446009389672},{"id":"*jd2U-FYTI8jCbQls","factoryName":"org.knime.base.node.preproc.filter.row.RowFilterNodeFactory","probability":0.08215962441314555},{"id":"*DOkyMaii62U05xZ1","factoryName":"org.knime.base.node.preproc.filter.column.DataColumnSpecFilterNodeFactory","probability":0.07981220657276995},{"id":"*JiJhJpgkWWuOfG2s","factoryName":"org.knime.ext.poi2.node.write2.XLSWriter2NodeFactory","probability":0.03755868544600939},{"id":"*Oy714gpoifm4PiOZ","factoryName":"org.knime.base.node.io.csvwriter.CSVWriterNodeFactory","probability":0.03051643192488263},{"id":"*VU5C_Qbl6sDSPXjl","factoryName":"org.knime.base.node.flowvariable.tablecoltovariable.TableColumnToVariableNodeFactory","probability":0.028169014084507043},{"id":"*5stmXk6zY_ORA4bC","factoryName":"org.knime.base.node.preproc.groupby.GroupByNodeFactory","probability":0.028169014084507043},{"id":"*OFhUBYYlMMQ7ZM3F","factoryName":"org.knime.base.node.flowvariable.tablerowtovariable.TableToVariableNodeFactory","probability":0.025821596244131457},{"id":"*rqhXsa-dMez9coq4","factoryName":"org.knime.base.node.preproc.transpose.TransposeTableNodeFactory","probability":0.023474178403755867},{"id":"*GC2Iaw9qTVMeDblF","factoryName":"org.knime.base.node.preproc.refcolumnresorter.ReferenceColumnResorterNodeFactory","probability":0.02112676056338028}]}
