Delete Bottom rows

Hello everyone.

I need to delete the last rows of a data base because they are “foot notes” or useless text, so I need to clean it up in order process the data correctly.

Keep in mind that as I download more data, this text will change its row to a lower one (from 60 to 70, for example)

Thanks, hope you can help me.

Hello @luise295
I would go with a simple ‘Row Filter’ node, applying a ‘regular expression’ (regex) about formatting:

\d{4}-\d{2}-\d{2}

You can try with a ‘Rule-based Row Filter’ node, about nulls in the following column in picture as well.

BR

6 Likes

If only your “footnote” rows have missing values you can use the Row Filter node configured like this pointed to the column with missing values:

3 Likes

Hello @luise295

While looking at the sample data set, I’m thinking about Row Filter node that includes 20* string (where * stands for a wildcard:

The expected outcome is generated:
image

Happy KNIMEing,
Kaz

3 Likes

Hi,
This will be dangerous if the workflow keeps running until the next century, though :wink:
Alexander

3 Likes

Right! ‘2*’ would be safer, however still not ideal :wink:
Thank you @AlexanderFillbrunn