File Showing wrong count

nilesh_kant · Post by **nilesh_kant** » Tue Jun 10, 2008 12:33 pm

Hi,

i am reading data from a sequential file with "First Row is Column name" set as true.The file has 100 records including the header. But the count in the link while running the job is showing as 100. ideally it should show as 99. The same file when i am running in other enviornment(Dev) i am able to see correct count i.e 99. Please tell why its behaving diferently in different enviornments.

ray.wurlod · Post by **ray.wurlod** » Tue Jun 10, 2008 5:00 pm

The header IS a row, and therefore is properly included in the row count, if "First line is column names" is False.

nilesh_kant · Post by **nilesh_kant** » Wed Jun 11, 2008 11:46 am

Ray,

The option "First Line is column names" is set to True which should mean that the header should not be taken as count while showing the total reords count. Also as I mentioned earlier When I am running the same job in different enviornment I am able to see correct count in the link coming out of the file. So is it enviormrnt issue or something else.

Any inputs on this willl be of grt help.

Thanks in Advance..

ag_ram · Post by **ag_ram** » Thu Jun 12, 2008 6:43 am

ray.wurlod wrote:The header IS a row, and therefore is properly included in the row count.

The header is NOT counted as a row if we set "First Line is column names" true.

nilesh_kant wrote:is it enviormrnt issue or something else.

It would NOT be an environment issue. Please check that option in the Sequential File Stage with a proper recompilation.