DSXchange

Hi,

I am trying to get the rowcount of the records from a flat file.

Design

Flatfile ---> Transformer ---> Flatfile

In transformer, am creating a new field which will contain the count of the records in the flatfile. The expression i am using is as below
I am getting only "0" as the rowcount. But it should be 11 and the job is running fine without throwing an error.

Thanks for your help in advance.

Regards,
Magesh

There are 2 problems with your code. The other problem is that this gets called for each row, so your first row value will be 1, the second row 2, etc. This would be more efficient by using @INROWNUM in a transform stage.

Why not use a filter command "wc -l" in your sequential file reading stage and you will get one row with one column containing just what you are looking for.