
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
RECNO() AND ROWNO()
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


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Which values are you calling "extra"?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
