 |
|||||
|
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. | |||||
Focal Point 
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED] DFIX format adds superfluous columns to output
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED] DFIX format adds superfluous columns to output Read-Only TopicGo | Search | Notify | Tools |
| [SOLVED] DFIX format adds superfluous columns to output | Login/Join |
| Member |
Hello! I am using WebFocus App Studio, version 8105m. The DFIX output format seems to add superfluous columns to my output. How do I get rid of these superfluous columns? Report code For example, I have the following very simple report code that should produce just two columns. It should produce a sort down column "Combined Statement Mail Code", as well as a computed count column "CNT_DST_MBR":
TABLE FILE MST_DIM_MBR
SUM
COMPUTE CNT_DST_MBR/I11 = CNT.DST.MST_DIM_MBR.MEMBER.MBR_NUM;
BY MST_DIM_MBR.MEMBER.COMB_STMT_MAIL_CD
WHERE MST_DIM_MBR.MEMBER.ETL_VERS_CURR_FLAG EQ 'Y';
ON TABLE PCHOLD FORMAT DFIX DELIMITER TAB HEADER YES
END
Expected results I expect it to produce the following tab delimited results with just those two columns: Combined Statement Mail Code CNT_DST_MBR A 79643 B 74807 C 270 D 1519 Observed results But instead, the report produces 4 columns. These are the observed results I get: Combined Statement Mail Code COUNT,DISTINCT,Member Number Member Number CNT_DST_MBR A 79643 0 79643 B 74807 0 74807 C 270 0 270 D 1519 0 1519 Help needed Note in the observed results, the 2nd column is pretty much a duplicate of the 4th, and the 3rd column "Member Number" is completely unexpected. How can I get rid of these superfluous columns? Thank you in advance for your help!This message has been edited. Last edited by: LoganW, -------------------------- LoganW WebFOCUS 8 Windows, All Outputs | ||
|
| Virtuoso |
Add: ON TABLE SET HOLDLIST PRINTONLY to your TABLE request. "There is no limit to what you can achieve ... if you don’t care who gets the credit." Roger Abbott | |||
|
| Virtuoso |
Hi Logan Welcome to Focal Point. I think you will find it very useful in getting quick answers to your development questions. I believe that Daryl's answer to your inquiry will resolve the issue you are having. Please update the post either way. If it is resolved please update the topic to have [SOLVED] at the beginning Thanks Thank you for using Focal Point! Chuck Wolff - Focal Point Moderator WebFOCUS 7x and 8x, Windows, Linux All output Formats | |||
|
| Member |
Thank you, Darryl! Yes, that does the trick! Those superfluous columns are no longer in the output. Thanks! -------------------------- LoganW WebFOCUS 8 Windows, All Outputs | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicFocal Point Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED] DFIX format adds superfluous columns to output
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED] DFIX format adds superfluous columns to outputCopyright © 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 |