{"title":"Constant Value Row Appender","nodeType":"Manipulator","id":"*k4Q1HIlGwZupSTmt","factoryName":"org.knime.base.node.preproc.addemptyrows.AddEmptyRowsNodeFactory","factoryId":"org.knime.base.node.preproc.addemptyrows.AddEmptyRowsNodeFactory","path":["Manipulation","Row","Other"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"<p>Adds a certain number of empty rows with missing values (or a constant) to the input table. This can be useful when used in a report table to ensure that a table has a minimum number of rows, which are then shown as blank rows. The content of the appended rows can be defined in the dialog, the default is to fill the corresponding cells with missing values. Note that the reporting engine allows you to format cells containing missing values (or any other specific value) using the &#34;Map&#34; feature. For instance, if you want to format missing values (shown as NaN in the report) as blank fields, add a map rule isNaN(row[&#34;Column x&#34;]), which needs to evaluate to True.</p>\n        ","shortDescription":"Adds a certain number of empty rows with missing values or a given constant to the input table.","keywords":["Add","Empty","Rows"],"deprecated":false,"streamable":false,"tags":["Manipulation","Row","Other"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAA3hpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNi1jMDY3IDc5LjE1Nzc0NywgMjAxNS8wMy8zMC0yMzo0MDo0MiAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wTU09Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9tbS8iIHhtbG5zOnN0UmVmPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvc1R5cGUvUmVzb3VyY2VSZWYjIiB4bWxuczp4bXA9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC8iIHhtcE1NOk9yaWdpbmFsRG9jdW1lbnRJRD0ieG1wLmRpZDowYjM2YWM5Ny01ZWJhLTQwZTctOTE4OS1iYmU4ZDdkMGYyNGUiIHhtcE1NOkRvY3VtZW50SUQ9InhtcC5kaWQ6ODlGNDhDMjYxNjhDMTFFNUJEOTVBMUI1OTFFQzZGQkIiIHhtcE1NOkluc3RhbmNlSUQ9InhtcC5paWQ6ODlGNDhDMjUxNjhDMTFFNUJEOTVBMUI1OTFFQzZGQkIiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIDIwMTUgKE1hY2ludG9zaCkiPiA8eG1wTU06RGVyaXZlZEZyb20gc3RSZWY6aW5zdGFuY2VJRD0ieG1wLmlpZDplYjRlYWE5NS1mMzM5LTQzZTctYmY1Yy0yNzFmOThkY2ZiMmIiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6MGIzNmFjOTctNWViYS00MGU3LTkxODktYmJlOGQ3ZDBmMjRlIi8+IDwvcmRmOkRlc2NyaXB0aW9uPiA8L3JkZjpSREY+IDwveDp4bXBtZXRhPiA8P3hwYWNrZXQgZW5kPSJyIj8+TBbNJgAAAHpJREFUeNpilBKX/s+ABP79+8fw4vVzBqA4XOz3n98Mr9++QhGDA5AB6AAoTJQYSC8TA4Vg4A1gARHSEjJwAYh3UcX+/P2DIQYDjDANFLmAWMDIyPgf3eKBD0SCYYDkbBpGIyFXIrH/o4vR3gXIYQQMDwxxihMSQIABAIKiXahIHDQhAAAAAElFTkSuQmCC","views":[],"inPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Input table","description":"Any input table"}],"outPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Output table","description":"Input table augmented by additional rows"}],"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":"Mode","description":"Choose whether to add a fixed number of rows to the input table (&#34;Additional&#34;), independent of the input table&#39;s row count; or to add rows to the table only in case there are less rows than indicated (&#34;At least&#34;). The latter will not change the input table if there are already more rows than specified in the corresponding field.","optional":false},{"name":"Count","description":"Number of rows to add or minimum number of rows in the output table.","optional":false},{"name":"RowID prefix","description":"Prefix for the RowIDs of newly added rows.","optional":false},{"name":"Number (Float)","description":"Fill value for Float columns in newly added rows.","optional":false},{"name":"Number (Integer)","description":"Fill value for Integer columns in newly added rows.","optional":false},{"name":"String","description":"Fill value for String columns in newly added rows.","optional":false}]}],"links":[],"kudos":[{"accountId":"account:user:c91a8e39-ad9c-463c-b196-20afc991ab53","user":"r_s","date":"2024-02-07T21:18:04+00:00"},{"accountId":"account:user:1a1cd743-25a6-451f-a3ce-74ba5cf76549","user":"15116397956","date":"2024-04-14T07:11:30+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":"*QNB4FsAPnEAgOMVh","factoryName":"org.knime.base.node.jsnippet.JavaSnippetNodeFactory","probability":0.06722689075630252},{"id":"*0rhLXWO6OS1xMi8T","factoryName":"org.knime.base.node.preproc.append.row.AppendedRowsNodeFactory","probability":0.058823529411764705},{"id":"*1eEd7ez8QADlHs0e","factoryName":"org.knime.base.node.switches.endif.EndifNodeFactory","probability":0.056022408963585436},{"id":"*6CbObXLq9oHq_EFi","factoryName":"org.knime.base.node.preproc.constantvalue.ConstantValueColumnNodeFactory","probability":0.05042016806722689},{"id":"*gwwIZ5c5EYsJErci","factoryName":"org.knime.base.node.preproc.sorter.SorterNodeFactory","probability":0.028011204481792718},{"id":"*zpGPAjDyExkFL2HB","factoryName":"org.knime.base.node.rules.engine.RuleEngineNodeFactory","probability":0.028011204481792718},{"id":"*1Uo48m8MIHW-seLx","factoryName":"org.knime.base.node.preproc.rowkey2.RowKeyNodeFactory2","probability":0.025210084033613446},{"id":"*OFhUBYYlMMQ7ZM3F","factoryName":"org.knime.base.node.flowvariable.tablerowtovariable.TableToVariableNodeFactory","probability":0.025210084033613446},{"id":"*2fI5rIsFDCFPHc0R","factoryName":"org.knime.ext.jep.JEPNodeFactory","probability":0.025210084033613446},{"id":"*rqhXsa-dMez9coq4","factoryName":"org.knime.base.node.preproc.transpose.TransposeTableNodeFactory","probability":0.025210084033613446}]}