Feature suggestion: Table to Cell node and "Data table" column type

Dear Knimers,

It think that it might be useful sometimes to wrap an entire table into a single cell, together with all the column headers and row indices. The node could be called “Table to Cell”. This cell would then have the type “Data table” and can be unwrapped into a full table with a “Cell to Table” node.

One application is that it could be a more concise alternative to Loop nodes with multiple input/output ports.

Best
Aswin

2 Likes

Hi @Aswin -

Interesting idea. I’ve created a ticket for it (AP-17131) and will update in this thread if there is any news.

3 Likes

You might want to check out these nodes

I used them to collect Excel files in a table (but maybe did not fully think the concept thru since I got some error messages on my Mac when storing the collection in a KNIME table)

Maybe you can expand on the concept. I have not tried it with a collection of KNIME tables. A table of tables could be the result.

1 Like

Dear @mlauber71 ,

I am not exactly sure what that does… Do I understand correctly that this work with a collection of KNIME tables on disk?

I would like to keep the data in the workflow itself. I can hack together components which kind of do this:

image

It starts with 2 tables:
image

and
image

By using a sequence of GroupBys and Column Aggregators it is possible to gather all the data into a single Collection cell:

These cells can then be concatenated:
image

…and subsequently unwrapped again into a full table:
image

But I think I can hear the Java memory management system / garbage collector scream in agony when I combine lists with different element types in this way :slight_smile:

Naively I don’t think that it should be hard to send whatever output the Table Writer node is creating to a table cell instead of a file, which would probably be more efficient than the method above.

Best
Aswin

KNIME_project14.knwf (61.3 KB)

1 Like

By chance I came across a pair of Erlwood nodes that essentially already do what I suggested (although without a special “Data table” column type):

2 Likes