Hi @victor_palacios,
I had a similar problem some time back Find frist date with non zero value in a time series and there where a KNIME solution and a python script solution. Maybe you want to check this out. You can easily modify the scripting solution to also remove the tail.
Best Regards,
Paul