As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at firstname.lastname@example.org and provide your corporate email address, company, and name.
First, you are unlikely to get many, if any, responses to your post when you put it here in the Events and Job Postings forum instead of in the WebFOCUS forum, where it belongs. Second, the sample code you provided produces an error and, even when fixed to prevent the error, does not produce anything like what you describe in your post. Finally, if you could give us an idea of what your text file looks like, there might be a more straight-forward way to produce the desired output than using OVER. But first, please, move this post to the WebFOCUS forum so it can get some attention.
Posts: 1213 | Location: Seattle, Washington - USA | Registered: October 22, 2007