Row filter mystery

Hi,

The answer must be stupid but...

I've got a table with 5 lines. I want to select the last row. So I use the row filter and use the include row by number with the First row number = 5 and the Last row number = 5.Ok it works.

Now I want to do it dynamically to select only the last row whatever the table dimension. Well, I use the Extract Table dimension node followed by the Table Column to Variable and adjust the flow variables panel to RowRangeStart=Number Rows and Row RangeEnd=Number Rows having Number Rows coming from the Table Column To Variable=5. But the result is an empty table.

Changing the parameters to 5 with a variable and "to the end of the table" as option give me too a void table.

Ok I put now the first variable to control the RowRangeStart to 4 using the other limit to "to the end of the table". The result is the fifth line as I wanted.

Then if I use now two variables one at 4 the other at 5 to control the limit then I obtain the fifth line. If you do it manually you obtain two lines the fourth and the fifth.

Conclusion : if you want to have the last line entering yourself your parameters you have to enter 5-5 but if you want to control the limits by variables you have to declare 4-5.

Workflow in attachment.

Best regards

Fabien

• row_filter_mystery.knwf