'Pentaho : Get Rowcount from a gz csv file

I need to find number of rows present in csv file but the csv file is compressed into gz format. I used "Get Files Row Count" but the rowcount value is wrong. If the actually CSV file has 80k rows it is returning around 38k. How can I achieve this problem?

enter image description here

enter image description here



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source