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