RECNO() AND ROWNO()

[gayathridevi24]

Hi All,

I am getting extra values of recno and rowno after loading. Could you please help me to solve this issue.

Please find the attached QVW file.

Thanks and Regards,

Gayathri Devi

[m_woolf]

Which values are you calling "extra"?

[gayathridevi24]

Hi Mwoolf,

I am getting blank extra column as attached in the screenshot below.

 

Please find the attached qvw file. Could you please help me to solve this issue.

Thanks and Regards,

Gayathri Devi

[marcus_sommer]

If you don't want to load these records you need to specify it within your load-statement by extending the where-clause maybe in this way:

where A<>2 and len(trim(A)) and len(trim(B));

- Marcus

[gayathridevi24]

Hi Marcus,

Yes am getting the results with what I have expected. Thank you so much for the reply. Could you please explain me the concept of len(trim()) with an example and its functionality and why want to use this function here.

Thanks and Regards,

Gayathri Devi