 |
|||||
|
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. | |||||
Read-Only TopicGo | Search | Notify | Tools |
| [SOLVED] Call all WF Gurus | Login/Join |
| Gold member |
I feel like I'm have a senior moment for something that I think is very simple and I have a feeling someone will get this solved for me within the hour. I've got 2 files. COURSES_REQUIRED and COURSES_TAKEN COURSES_REQUIRED 1 - Course 1 2 - Course 2 3 - Course 3 COURSES_TAKEN 1 - John Doe 3 - Mary Jane And I need my output to be: 2 - Course 2 - John Doe 3 - Course 3 - John Doe 1 - Course 1 - Mary Jane 2 - Course 2 - Mary JaneThis message has been edited. Last edited by: FP Mod Chuck, WebFOCUS 8 Windows, All Outputs | ||
|
| Virtuoso |
So you're trying to find out what required courses John and Mary Have not yet taken? WebFOCUS 8206, Unix, Windows | |||
|
| Gold member |
Yes WebFOCUS 8 Windows, All Outputs | |||
|
| Virtuoso |
Something like this?:
SET SHORTPATH = SQL
JOIN LEFT_OUTER
COURSE IN COURSES_REQUIRED TAG R TO MULTIPLE
COURSE IN COURSES_TAKEN TAG T AS J0
END
TABLE FILE COURSES_REQUIRED
PRINT T.STUDENT
BY R.COURSE
WHERE T.COURSE IS MISSING;
END
WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010 : Member of User Group Benelux : | |||
|
| Gold member |
That's what I was trying but my output does not contain the employee information, only the courses they did not take. WebFOCUS 8 Windows, All Outputs | |||
|
| Expert |
Wep5622's solution should work, the solution is simple, join every row to every row and throw away the ones that match. If the join fails to work, you could try holding the two files with a dummy field, say A1 of blank, and join on that. Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Gold member |
And the winner is Waz. Thanks Waz  WebFOCUS 8 Windows, All Outputs | |||
|
| Expert |
Can we all say A1 of blank... and JOIN   | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only Topic | 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 |