Detect First row and First Column in a table

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?

@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:

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:

@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.

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)

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