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,

Add: ON TABLE SET HOLDLIST PRINTONLY to your TABLE request.

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, Darryl! Yes, that does the trick! Those superfluous columns are no longer in the output. Thanks!