Detect First row and First Column in a table

[Morno]

Hello everyone,

I am facing a problem that has me puzzled. Can anyone tell me if it is possible to identify in which cell and column my table starts and ends?

How I show in the picture, my table start in row 4 column 1 and end in row 16 column 4. The values that I need is (1,4) - (16,4).

Some ideas?

[mlauber71]

@Morno welcome to the KNIME forum. Could you define what would constitute a start of a row. Why is ist “Row4” and not (eg.) “Row2” which also contains values (or “Row3” for that matter).

The same goes for the end of a table. Would there just be one table or more.

One option to define data blocks is illustrated here:

Move head rows to a column

@willy_oracle typically you would mark all lines with a Counter. Then identify the ‘headers’ with a rule engine [IF Col1 LIKE “Head*” => Counter] and keep that (starting) row in a separate column. Then you fill the missings with the previous value so a block would emerge marking the data table: [image] So now you have the blocks marked an can use a Table Row to Variable Loop Start – KNIME Community Hub or Group Loop Start – KNIME Community Hub to do something with the blocks (export them delet…

[Morno]

Checking the column order, a table starts with a value that has no null (0) in at least 3 consecutive rows and at least 3 columns to the right with non-null (0) values.

The table ends when a cell has null values in at least 3 consecutive rows or when there are no more columns/cells.

There are no more tables because the workflow takes one by one per id.

I attach some more examples:

[mlauber71]

@Morno maybe you could add examples as files and not just screenshots. It would be good if some ‘edge’ cases could be included to be able to test a concpet.

[Morno]

I can’t add edges cases because the workflow is so simple like the table.

Node 1 is the original table with their ID and how the values are.
Node 2 is the expected outcome.

Test_Find_Row_Column.knwf (13.6 KB)