 |
|||||
|
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. Join the TIBCO Community
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community. | |||||
Read-Only TopicGo | Search | Notify | Tools |
| Next Record | Login/Join |
| Platinum Member |
I run into this problem all the time and wanted to know how others solved it. Let's say I have 5 records sorted by date and I want to pick out the two records whose dates are within 30 days of each other. What I have been doing in the past is making a flag that says FLAG/A2 = IF (DATE - LAST DATE) LE 30 THEN 'A' ELSE ' '; but that only flags the second record of the two that I want. Is there a way to say "if this record is within 30 days of the previous record then flag the current record and the previous record"? Thanks for the help! Windows version 768 | ||
|
| Virtuoso |
I think when you put the first reult in a hold file and than create the same action but now sorted descending you will get the result you want. if you have many many records it will take some time....
| |||||||
|
| Expert |
if i understand you correctly, that LAST RECORD has 2 comparisons that make it eligible for display, is comparison to the record AFTER it, and to the record BEFORE it, is that correct? if so, then Frank's suggestion is the good one. process the file in ascending order comparing to last record, and create a flag DISPLAY/I1 = 1 OR 0 depending on your decision. then process the resultant file in DEscending order, keeping the DISPLAY field, and calculating a new one, 1 if DISPLAY is already a 1 and then based on the regular comparison determination to its own LAST record, if the incoming DISPLAY value had been 0. then just print out everything where this DISPLAY value is 1. There's probably a macgyerish way to join this file to itself upside down and make the determination in 1 fell swoop... so maybe someone will come along and show us how to do that.
| |||||
|
| Platinum Member |
Thanks to both of you. I have been doing it that way (sorting in descending after first hold). Thanks again! Windows version 768 | |||
|
| Guru |
If you have not too many rows, Maintain would be useful. Eg. x = stk.focindex; if stk(x).date - stk(x-1).date lt 30 then begin type on out "<stk(x).date <stk(x-1).date"; endbegin that will give you a row with the two dates on the text file out. Håkan WebFOCUS DS 8.0.06/08 DS/AS WebFOCUS RS 8.0.08 (Linux/IBM i) WebFOCUS Client 8.0.06 (Linux) | |||
|
| Virtuoso |
Mark I was thinking on this issue again. Why do you want to do this? The solution technical works but what can happen if you do it this way is that you get a lot of flags and they do tell you nothing anymore. I tried something with the following figures date diff days 15-jan 17-jan 2 24-jan 7 14-feb 21 18-feb 4 28-feb 10 3-mrt 3 17-mrt 14 22-mrt 5 31-mrt 9 1-apr 1 8-apr 7 25-apr 17 If the cluster is 2 days you would get a flag on only 31/mar and 1/apr so that looks ok, but if the difference would we 8 days you should get flags on all the lines and some dates would be part of two clusters. Than it is not working anymore. I do not have the proper solution, but what might help is not giving all the clusters the same code but making that code the lowest or highest of the two days.
| |||||||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicCopyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |