topic Re: RECNO() AND ROWNO() in QlikView

RECNO() AND ROWNO()

gayathridevi24 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: RECNO() AND ROWNO()

m_woolf — Tue, 28 May 2019 16:54:37 GMT

Which values are you calling "extra"?

Re: RECNO() AND ROWNO()

gayathridevi24 — Wed, 29 May 2019 05:05:20 GMT

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

Re: RECNO() AND ROWNO()

marcus_sommer — Wed, 29 May 2019 10:56:26 GMT

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

Re: RECNO() AND ROWNO()

gayathridevi24 — Thu, 30 May 2019 06:06:33 GMT

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