Focal Point Banner


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
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

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  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Problems whit CNT.DST

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] Problems whit CNT.DST
 Login/Join
 
expertomad
Gold member
posted
This is example no is ok .
I want count distinct less white space.
DEFINE FILE SALES
CAMPO1/A17 = IF AREA EQ 'S' THEN CITY ELSE ' ' ;
CAMPO2/A17 = IF AREA EQ 'U' THEN CITY ELSE ' ' ;
END
TABLE FILE SALES
PRINT
CAMPO1 CAMPO2
ON TABLE HOLD AS PRUEBA FORMAT ALPHA
END
TABLE FILE PRUEBA
SUM
COMPUTE CAMPO11/I10 = CNT.DST.CAMPO1 -1;
COMPUTE CAMPO22/I10 = CNT.DST.CAMPO2 -1;
-*ON TABLE HOLD AS PRUEBA3 FORMAT ALPHA
END

Sombody can help me please

This message has been edited. Last edited by: Kerry,
 
Posts: 62 | Registered: September 18, 2008Report This Post
Dave
Master
posted Hide Post
Hi,

you're on the right track.

You're problem is with 2 × CNT.DST.
We've had a lot of trouble with it to.

The seems to be a big difference between:
SUM COMPUTE CD1/D12 = CNT.DST.FIELD_ONE;
    COMPUTE CD2/D12 = CNT.DST.FIELD_TWO;
BY  ...


and

SUM CNT.DST.FIELD_ONE
    CNT.DST.FIELD_TWO
BY  ...


The first one is handled by WF.
The second is passed to the SQL.

( [!] This difference doesn't occur with the CAR master sample. Only with out real masters. )


First, test wether the CNT.DST work. Make sure this does want you expect.

If it does, then try to exclude ' ' with the -1.


_____________________
WF: 8.0.0.9 > going 8.2.0.5
 
Posts: 668 | Location: Veghel, The Netherlands | Registered: February 16, 2010Report This Post
expertomad
Gold member
posted Hide Post
You could help me , the first count ok but second count no ok .
Sorry my english no is very good.

I need count good in the fields
 
Posts: 62 | Registered: September 18, 2008Report This Post
expertomad
Gold member
posted Hide Post
thanks for everything
 
Posts: 62 | Registered: September 18, 2008Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Problems whit CNT.DST

Copyright © 1996-2020 Information Builders