 |
|||||
|
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 |
| Issue with the Group BY | Login/Join |
| Platinum Member |
I am using variable BY A BY B The ouprput will be A1 B1 B2 B3 A2 B1 B2 This is the normal output But my requirement is A1 B1 B2 B3 A2 B1 B2 How to achive this one? WebFOCUS 7610 Windows | ||
|
| Gold member |
 You wrote above and below - identical. WF 7.6.2, WinNT/2K, MSSQL 2K, MSOLAP 2K, BID | |||
|
| Platinum Member |
Sorry A1 B1 B2 B3 A2 B1 B2 This is normal o/p. But i want A1 B1 B2 B3 A2 B1 B2 WebFOCUS 7610 Windows | |||
|
| Platinum Member |
The ouprput will be A1 B1 B2 B3 A2 B1 B2 This is the normal output But my requirement is A1 B1 B2 B3 A2 B1 B2 How to achive this one? WebFOCUS 7610 Windows | |||
|
| Gold member |
Hm... Maybe you want this? TABLE FILE CAR BY COUNTRY NOPRINT BY CAR ON COUNTRY SUBHEAD "<COUNTRY " END WF 7.6.2, WinNT/2K, MSSQL 2K, MSOLAP 2K, BID | |||
|
| Platinum Member |
Hi Ingas i tried this method But i got A1 B1 A1 B2 A1 B3 For every row i am getting the A1 .... That is the issue WebFOCUS 7610 Windows | |||
|
| Gold member |
Hi! I'm not a guru (and I suspect that you want smth much simpler). But look: SET ASNAMES = ON SET HOLDLIST = PRINTONLY TABLE FILE CAR BY COUNTRY PRINT COMPUTE COUNTRY_CAR/A16 = IF COUNTRY EQ LAST COUNTRY THEN CAR ELSE COUNTRY; AS 'CAR' ON TABLE HOLD AS 'CC_HOLD' END TABLE FILE CC_HOLD BY COUNTRY BY CAR ON TABLE HOLD AS CC_HOLD2 MORE FILE CAR END TABLE FILE CC_HOLD2 BY COUNTRY PRINT CAR COMPUTE SORT_ORDER/I1 = IF COUNTRY EQ CAR THEN 0 ELSE 1; ON TABLE HOLD AS FINAL_HOLD END TABLE FILE FINAL_HOLD BY COUNTRY NOPRINT BY SORT_ORDER NOPRINT BY CAR AS COUNTRY_THEN_CAR END I suppose gurus can make it in one or two operations. (And I suppose that SUBHEAD is what you want indeed) WF 7.6.2, WinNT/2K, MSSQL 2K, MSOLAP 2K, BID | |||
|
| Platinum Member |
Thanks Ingas ... i will try with this WebFOCUS 7610 Windows | |||
|
| Expert |
Gobinath, Firstly, please update your signature as per this friendly request. Secondly, you have placed this question twice. Finally, Ingas gave you the simplest solution for your question and it should work. Perhaps you did not apply it properly? TABLE FILE filename BY A NOPRINT BY B ON A SUBHEAD "<A" END Simple, and it gives you exactly what you wanted. T
| |||||||||
|
| Platinum Member |
Thanks Tony .... It is working fine WebFOCUS 7610 Windows | |||
|
| Platinum Member |
Hi Tody I achived the last one Now TABLE FILE HOLD BY A1 BY A2 My Requirement is A1 A2 How to achive this ?? WebFOCUS 7610 Windows | |||
|
| Expert |
Gobinath, First update your signature as you have been asked several times T
| |||||||||
|
| 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 |