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     Picking correct Phone Number

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Picking correct Phone Number
 Login/Join
 
<Vijaya_settu>
posted
Hello Everyone,
I‘ve a problem picking correct phone number. For Ex. The following example the person’s current resident phone number is 2’nd row and the phone number is “222-222-2222”. The I’st row is that person’s former address. For ex.If another person has ten former address, it is keep on adding at the top and current address is somewhere in the middle or last. Our phone number table data is little bit messed up. My problem is to hard pick the current resident phone number. I appreciate any thought regarding this issue.

Id pos Phone Number Phone Type
1111 1 111-111-1111 H
2222 2 222-222-2222 H
3333 3 333-333-3333 W
 
Report This Post
GinnyJakes
Expert
posted Hide Post
So how do you identify the current? Is there a date on the record or something like that? There has to be something there that you can test or sort on.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
<Vijaya_settu>
posted
Thanks ginny for your quik reply,
I usally use where criteria WHERE POS EQ "1" for getting the current resident phone numer .But after the phone number migration phone table structure got changed. Now POS EQ "1" is former address phonenumber.

Vijaya
 
Report This Post
GinnyJakes
Expert
posted Hide Post
Nothing is going to work unless you can identify which one is current, either a date updated field newer than the rest or some sort of switch.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
FrankDutch
Virtuoso
posted Hide Post
So how would you pick the correct number if it was all in Excel? (or printed out)

You need to give us more data to understand your problem.
You can sort by highest 1 xxx




Frank
prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Report This Post
<JG>
posted
As Ginny says it would be most unusual for a data source not to identify the current or active value.

However if it always the last entry, then using SUM on an alpha field always populates with the 'last'
value (providing you do not do anything to change the sort order).

for example

TABLE FILE CAR
PRINT MODEL
BY COUNTRY
WHERE COUNTRY EQ 'ENGLAND'
END
-RUN
TABLE FILE CAR
SUM MODEL
BY COUNTRY
WHERE COUNTRY EQ 'ENGLAND'
END

If you genuinely want some summated items and some print items use a multi-verb request.
(but again do not mess with the sort order of the incomming data.

TABLE FILE CAR
SUM MODEL
BY COUNTRY
PRINT MODEL
BY COUNTRY
END
 
Report This Post
j.gross
Virtuoso
posted Hide Post
Sort of like those Netflix radio ads.


- Jack Gross
WF through 8.1.05
 
Posts: 1925 | Location: NYC | In FOCUS since 1983 | Registered: January 11, 2005Report This Post
<JG>
posted
Jack, That must be a US'ism because I have no idea what you're talking about.
 
Report This Post
j.gross
Virtuoso
posted Hide Post
JG: Yes it is. -- To rephrase that in more universal terms, the challenge seems analogous to solving 2 simultaneous linear equations in 5 variables: No solution without more information.

Back to topic:


VJ:

If there are no surviving attributes for dating or sequencing the rows ... My next tack would be a comparison (think MATCH FILE) of the present data-store against the original (you do have backups, right?). With a little experimentation one should be able to determine the most-current as of the old file's provenance date, and identify rows added or changed subsequently. Even if that leaves some residual ambiguities, it should reduce the volume to the point where it can be ironed out manually.


- Jack Gross
WF through 8.1.05
 
Posts: 1925 | Location: NYC | In FOCUS since 1983 | Registered: January 11, 2005Report This Post
Bhanu
Member
posted Hide Post
Can be done in two passes.
1st pass : create a HOLD1 file all the records WHERE REROCRDS OMITES '-' (as the line with - will be the phone record) along with the KEY

2nd Pass : create HOLD1 file for WHERE RECORD CONTAINS '-' along with KEY

Then you play the way you want.
 
Posts: 8 | Registered: January 25, 2007Report 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     Picking correct Phone Number

Copyright © 1996-2020 Information Builders