{"title":"Table Row to Variable","nodeType":"Other","id":"*fI6e-FYDCsugy9m_","factoryName":"org.knime.base.node.flowvariable.tablerowtovariable3.TableToVariable3NodeFactory","factoryId":"org.knime.base.node.flowvariable.tablerowtovariable3.TableToVariable3NodeFactory","path":["Workflow Control","Variables"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"<p>This node uses the first row of a data table to define new flow variables. The names of the variables are defined by the column names and the variable assignments (i.e. the values) are given by the values in the row. The variables are exposed using a variables out connection.</p>\n        ","shortDescription":"Defines new flow variables based on the first row of the input table and exposes\nthem using a variable connection.","keywords":[],"deprecated":false,"streamable":false,"tags":["Workflow Control","Variables"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAA3hpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNi1jMDY3IDc5LjE1Nzc0NywgMjAxNS8wMy8zMC0yMzo0MDo0MiAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wTU09Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9tbS8iIHhtbG5zOnN0UmVmPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvc1R5cGUvUmVzb3VyY2VSZWYjIiB4bWxuczp4bXA9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC8iIHhtcE1NOk9yaWdpbmFsRG9jdW1lbnRJRD0ieG1wLmRpZDowYjM2YWM5Ny01ZWJhLTQwZTctOTE4OS1iYmU4ZDdkMGYyNGUiIHhtcE1NOkRvY3VtZW50SUQ9InhtcC5kaWQ6MkIwNzVGQUE0NUM3MTFFNUFDNkJBNzc0MkI4RTNBMkQiIHhtcE1NOkluc3RhbmNlSUQ9InhtcC5paWQ6MkIwNzVGQTk0NUM3MTFFNUFDNkJBNzc0MkI4RTNBMkQiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIDIwMTUgKE1hY2ludG9zaCkiPiA8eG1wTU06RGVyaXZlZEZyb20gc3RSZWY6aW5zdGFuY2VJRD0ieG1wLmlpZDpiMjZmMjcxNS1kZmZiLTRlYTgtYWJjMi0xZDk4N2YzMzE1NzIiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6MGIzNmFjOTctNWViYS00MGU3LTkxODktYmJlOGQ3ZDBmMjRlIi8+IDwvcmRmOkRlc2NyaXB0aW9uPiA8L3JkZjpSREY+IDwveDp4bXBtZXRhPiA8P3hwYWNrZXQgZW5kPSJyIj8+y0Ox5wAAAI1JREFUeNpiZGBg+M9AAWABEf//k2cGIyMjAxMDhWAYGMBIaSzAADsQs1FiAD5X3AXiZ0h8Qaj6VcSGwSwglgRiYyg/FEqvxuUCELsJi43lUD7I5u/oCfA/DsyApAnmDZDmDnwpGCTagCbmAhVPg9LGMAMYSQjod1D6BxBLkRNT5WhhAUlI5OZEGAAIMACB0S5sgw1IUgAAAABJRU5ErkJggg==","views":[],"inPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Parameters table","description":"The table whose first row will be converted to variables."}],"outPorts":[{"objectClass":"org.knime.core.node.port.flowvariable.FlowVariablePortObject","color":"ff4b4b","dataType":"Flow Variable","optional":false,"name":"Variables Connection","description":"Holds created flow variables."}],"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":"Output as variables","description":"Select the columns to be converted to flow variables. For each selected column, a flow variable is created. The name of the flow variable corresponds to the column name and the value corresponds to the value of the first row in that column.","optional":false},{"name":"If value in cell is missing","description":"Behavior in case of missing values in the first row or an input table with no rows.\n<ul><li><b>Use defaults</b> : Replaces missing values with the configured defaults. If a column has a type for which no flow variable type exists, the default value for missing strings will be output. If the column holds lists or sets of string, boolean, double, integer, or long, an empty list of the according type will be output. If the column holds lists or sets of another type, an empty string list will be output.</li><li><b>Ignore</b> : Missing cells will not be converted and therefore be omitted from the output.</li><li><b>Fail</b> : Ensures that the node will fail during execution if the input table is empty or contains missing values in the columns to convert.</li></ul>","optional":false},{"name":"Default string","description":"The default flow variable value for string columns in case of an empty input table or a missing value in the first row of the input table.","optional":false},{"name":"Default boolean","description":"The default flow variable value for boolean columns in case of an empty input table or a missing value in the first row of the input table.","optional":false},{"name":"Default integer","description":"The default flow variable value for integer columns in case of an empty input table or a missing value in the first row of the input table.","optional":false},{"name":"Default long","description":"The default flow variable value for long columns in case of an empty input table or a missing value in the first row of the input table.","optional":false},{"name":"Default double","description":"The default flow variable value for double columns in case of an empty input table or a missing value in the first row of the input table.","optional":false}]}],"links":[],"kudos":[{"accountId":"account:user:fd74d1b4-da47-4c58-86e7-4fdd8c45dce0","user":"lukass","date":"2022-12-19T13:27:30+00:00"}],"kudosCount":1,"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":[]}