Table to txt or xls

KNIME Analytics Platform
1

Hello Knimers,

I already created a workflow, with the final result of a table view. I need this table view exported in a excel or even better in a text file.

I found a node “text output widget” but I can not connect it.

It would be nice if you could help me out.

Thank you in advance :slight_smile:

2

Hi Alex,

there’s an Excel Writer node:

For “txt” it depends on the format you’d like. Typically you would export table structures in CSV format. For that you can use the CSV Writer:

Does this help?

– Philipp

PS: It’s worth having a look at the other nodes in the “IO -> Write” section. There are many more file types to which you can output:

2 Likes
3

Hello Philipp,

first of all thanks for your fast response. With the excel writer I got the format I want, but as I see the CSV Writer is what I need. But if I use the CSV Writer, all the coloumns will be exported, I need just one row of it. Do you know how I can filter it?
In the previous node “Table View” I have just one column named “row4” everything else is hidden.

Br Alex

4

Hey there,

that’s simple, just add a Column Filter before the CSV Writer:

Kind regards,
Philipp

2 Likes
5

Perfect, thanks a lot :slight_smile:

6

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.