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    Search    Search Results
Page 1 ... 27 28 29 30 31 
Go
Search
Tools
Search Results: (603 matches) New Search Login/Join 

Discussion Topic  RE: [SOLVED] Running Total Reset (in WebFOCUS/FOCUS Forum on Focal Point ) by RobertF
Hmmm...seems to make perfect sense but upon doing so, I loose my running totals alltogether... TABL......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  [SOLVED] Running Total Reset (in WebFOCUS/FOCUS Forum on Focal Point ) by RobertF
Essentially, the code below is succefully creating a running total for the 4 fields shown. The troub......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] CONVERSION OF MDYY filed (in WebFOCUS/FOCUS Forum on Focal Point ) by RobertF
Just wanted to thank you all...COMPUTE DATE_DAY/D = DATE_MDYY ; is working....
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] CONVERSION OF MDYY filed (in WebFOCUS/FOCUS Forum on Focal Point ) by RobertF
Thanks all, when we get our server back I'll give it a go.......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] CONVERSION OF MDYY filed (in WebFOCUS/FOCUS Forum on Focal Point ) by RobertF
thanks.. I will try......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] CONVERSION OF MDYY filed (in WebFOCUS/FOCUS Forum on Focal Point ) by RobertF
hovering over the field...Format: MDYY....was told its numeric......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  [SOLVED] CONVERSION OF MDYY filed (in WebFOCUS/FOCUS Forum on Focal Point ) by RobertF
I have searched the forum and found numerous discussions but not one the gets me exactly what I need......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: Match pulls appropriate # of rows but 'lookup value' not always returned (in WebFOCUS/FOCUS Forum on Focal Point ) by RobertF
btw, the join code above gets the right number of records...the copay is always blank though......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: Match pulls appropriate # of rows but 'lookup value' not always returned (in WebFOCUS/FOCUS Forum on Focal Point ) by RobertF
FYI...the MATCH now works...the JOIN however does not...if anyone is interested the code is below. ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: Match pulls appropriate # of rows but 'lookup value' not always returned (in WebFOCUS/FOCUS Forum on Focal Point ) by RobertF
Well, it worked HOWEVER not at first. I noticed my second key values: TRXNBRFSCKEY were not spelled......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: Match pulls appropriate # of rows but 'lookup value' not always returned (in WebFOCUS/FOCUS Forum on Focal Point ) by RobertF
still no luck with the match either...I get an error on the BY FST.PATIENT_ID line... TABLE FILE HT......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: Match pulls appropriate # of rows but 'lookup value' not always returned (in WebFOCUS/FOCUS Forum on Focal Point ) by RobertF
I wish I could be more successful with joins. I just took my HTEMP file. I buit a new hold file: H......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: Match pulls appropriate # of rows but 'lookup value' not always returned (in WebFOCUS/FOCUS Forum on Focal Point ) by RobertF
thanks, again I need to time to absorb this *new* way of thinking....how a simple join can be made s......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: Match pulls appropriate # of rows but 'lookup value' not always returned (in WebFOCUS/FOCUS Forum on Focal Point ) by RobertF
The SUM did not seem to do anything....was this what you had in mind? MATCH FILE HTEMP PRINT HT......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: Match pulls appropriate # of rows but 'lookup value' not always returned (in WebFOCUS/FOCUS Forum on Focal Point ) by RobertF
Thanks guys...still trying to absorb all this. Both files are local hold files. I immediately noti......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  Match pulls appropriate # of rows but 'lookup value' not always returned (in WebFOCUS/FOCUS Forum on Focal Point ) by RobertF
Table HTEMP has 44 rows. The BY field combinations:HTEMP.HTEMP.PATIENT_ID and HTEMP.HTEMP.TRXFSCNBRK......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: Quick Match Syntax Question (in WebFOCUS/FOCUS Forum on Focal Point ) by RobertF
thanks again...I thought I tried that but it did not work...I will try again-it would be easier that......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: Quick Match Syntax Question (in WebFOCUS/FOCUS Forum on Focal Point ) by RobertF
THANKS! I am getting there...allbeit slowly!...
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: Quick Match Syntax Question (in WebFOCUS/FOCUS Forum on Focal Point ) by RobertF
and finally...the fields are of differing types...t1.Invoice_Number is AV8 and t2.Invoice_Number is......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: Quick Match Syntax Question (in WebFOCUS/FOCUS Forum on Focal Point ) by RobertF
further....I have another situation where the BY fields in the two tables to be matched have differe......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point


» Refine Search
» New Search

  Powered by Social Strata Page 1 ... 27 28 29 30 31  

Focal Point    Focal Point Forums    Search    Search Results

Copyright © 1996-2020 Information Builders