 |
|||||
|
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] Using an Uploaded Data File in a Join
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED] Using an Uploaded Data File in a Join Read-Only TopicGo | Search | Notify | Tools |
| [SOLVED] Using an Uploaded Data File in a Join | Login/Join |
| Member |
In WebFOCUS, I used the Upload Data File option to bring in an Excel file that has 3 columns. Every row in the first column is unique and is equal to a value in an existing data file. The second column has the same value on each row, and the third column contains various amounts. When I tried to select the uploaded file for a JOIN to an existing data file, I received the following error: "Selected FOCUS master file does not have indexed fields. Please select another master file." Does anyone know of a way to assign an index to an uploaded file, or to otherwise correct this error?This message has been edited. Last edited by: Kerry, 7.6.4 Red Hat Enterprise Linux Excel, CSV, HTML, PDF, perhaps others also | ||
|
| Virtuoso |
If you use this uploaded file as the from file, then it does not need indexes. Only the join-to file needs indexes, if it is a focus file. From your description the join-to is not the uploaded one but an existing data file. That's the one that needs indexes. You can do this in a number of ways: - use the rebuild utility - use the method of table, recreate the file with indexes in the master, and modify to load it again - maybe convert it to sql - then you do not need indexes anymore - table file, hold format focus with indexes, rename. Hope this helps ... GamP
| |||||||||
| ||||||||||
| Expert |
If neither file is a FOCUS file, then they must be sorted in the same order by the same BY fields. If you TABLE and HOLD them first to sort, then you should be able to do the join. 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 | |||
|
| Expert |
If you TABLE , HOLD, then you might as well HOLD FORMAT FOCUS INDEX column. If only IB had put in all the functionality of my xlreader process into the Upload Data File option, you could have created a FOCUS file.  Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Member |
Thanks all, for your replies. These solutions sound straight-forward. It may take more than a couple of days before I can try them out. The existing table is my "join from", as it contains all key records, and the uploaded tables only contain subsets of the key records. 7.6.4 Red Hat Enterprise Linux Excel, CSV, HTML, PDF, perhaps others also | |||
|
| 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] Using an Uploaded Data File in a Join
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED] Using an Uploaded Data File in a JoinCopyright © 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 |