Separating final column

hello i would like to know if there is a way of separating the final column of an excel, the name is always random and the amount of columns is random but i need to work in a loop since it will be over 100 documents each one with a different value that i need the only consistent part is that is in the final column so i would like to know if there is a way to separate the final column from a excel (maybe a node or some way of coding into deleting every thing except the final column)

Hi @Bleck, if you are using KNIME 5.x, there is the new Table Cropper node that can do this.

After your Excel Reader, attach Table Cropper and you can configure it as follows:

In KNIME 4.x, I can only think of doing it in a more involved way:

Sorter:

Row Filter:

Table Row to Variable:

Column Filter:


2 Likes

thank you very much this worked perfectly

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