Icon

KN-111 Copy and Paste Tables with Headings v05

[KNIME Nodes] KN-111 Copy and Paste Tables with Headings

[KNIME Nodes] KN-111 Copy and Paste Tables with Headings

KNIME shortcut to copy-and-paste the output table data, along with table headings, to Excel.

A comprehensive description of this workflow with step-by-step instructions can be found at the Scientific Strategy website:
https://scientificstrategy.com/kn-111/

KNIME Nodes (KN-111) - Copy-and-Paste Tables with HeadingsPart 1: When copying the output from a KNIME node to the clipboard only the datais copied, not the table headings. This trick will append the table headings to thetop of the data table so you can copy-and-paste everything into Excel. KNIME Nodes (KN-111) - Copy-and-Paste Tables with HeadingsPart 2: Copy a Correlation Matrix with Column Headings as well as RowIDs KNIME Nodes (KN-111) - Copy-and-Paste Tables with MetanodePart 3: The workflow used to create a table that can be copy-and-pasted can bewrapped in a KNIME Metanode. Metanodes can be used to clean-up and simplifyworkflows by hiding implementation details. Instructions:Right-Mouse-Click = Open Output table, then Ctrl-A (Select All) and Ctrl-C (Copy)Double-Click = Open the Metanode for editing Get TableHeadingsCola ProductsFeature TableHeadings+ DataGet ColumnHeadersHeaders+ DataProductsSortProduct ColumnsCola WarsProduct CorrelationsCola ProductsFeature TableHeadings+ Data ExtractColumn Header Table Creator Concatenate ExtractColumn Header Concatenate RowID Column Resorter Table Reader Table Creator Copy andPaste Output KNIME Nodes (KN-111) - Copy-and-Paste Tables with HeadingsPart 1: When copying the output from a KNIME node to the clipboard only the datais copied, not the table headings. This trick will append the table headings to thetop of the data table so you can copy-and-paste everything into Excel. KNIME Nodes (KN-111) - Copy-and-Paste Tables with HeadingsPart 2: Copy a Correlation Matrix with Column Headings as well as RowIDs KNIME Nodes (KN-111) - Copy-and-Paste Tables with MetanodePart 3: The workflow used to create a table that can be copy-and-pasted can bewrapped in a KNIME Metanode. Metanodes can be used to clean-up and simplifyworkflows by hiding implementation details. Instructions:Right-Mouse-Click = Open Output table, then Ctrl-A (Select All) and Ctrl-C (Copy)Double-Click = Open the Metanode for editing Get TableHeadingsCola ProductsFeature TableHeadings+ DataGet ColumnHeadersHeaders+ DataProductsSortProduct ColumnsCola WarsProduct CorrelationsCola ProductsFeature TableHeadings+ Data ExtractColumn Header Table Creator Concatenate ExtractColumn Header Concatenate RowID Column Resorter Table Reader Table Creator Copy andPaste Output

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: Berlin
Created at: 2018-06-11
On NodePit since: 2021-02-05
Last update: 2024-04-27
Created with KNIME version: v3.7.1

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!