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     Can I Join a File By Columns

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Can I Join a File By Columns
 Login/Join
 
slfmr
Platinum Member
posted
What I am asking is when you execute a Join, the field you join on is placed in the same row.

JOIN ID IN EMPINFO TO
ID IN DEPINFO AS J1
END

Table would look like this:

ID Name ID Name
12 Harry 12 Shiela

Is there a way to do a Join or a Match where the output would look like this:

ID Name
12 Harry
12 Shiela

And if they also have additional field columns that do not match, just have them append to the table columns, like normal match's do?

Thank you for your assistance!


Dev, SIT, UAT, Production:7.6.6
Dev Sandbox:7.6.11

Dev Studio - 7.6.6
 
Posts: 178 | Registered: May 11, 2005Report This Post
reFOCUSing
Guru
posted Hide Post
Are you trying to append the two data sets together? If so give FILEDEF, MORE or USE a try.

This message has been edited. Last edited by: reFOCUSing,
 
Posts: 406 | Location: Canada | Registered: May 31, 2004Report This Post
TexasStingray
Master
posted Hide Post
What reFOCUSing said is good 

  
TABLE FILE xxxx
PRINT
...
...
MORE yyyy
...
...
END


should work for you




Scott

 
Posts: 865 | Registered: May 24, 2004Report This Post
slfmr
Platinum Member
posted Hide Post
Is the yyyy the other Hold File Name?

Would it be:

TABLE FILE Hold1Name
Print
---
---
MORE Hold2Name
---
---
END

Thank you for your help!


Dev, SIT, UAT, Production:7.6.6
Dev Sandbox:7.6.11

Dev Studio - 7.6.6
 
Posts: 178 | Registered: May 11, 2005Report This Post
TexasStingray
Master
posted Hide Post
  
TABLE FILE CAR
PRINT
COUNTRY
ON TABLE HOLD AS HOLD1
MORE
FILE CAR
END

TABLE FILE HOLD1
PRINT *
BY COUNTRY
END


This does not JOIN the files it merges them




Scott

 
Posts: 865 | Registered: May 24, 2004Report This Post
<JG>
posted
First I would like to say that your join would never produce the results that you describe.
Second if you have multiple names associated with the same id and a single key then your system will never work correctly, because it is totally incorrect to have multiple names in a DBMS associated with a single key which is/should usually be a unique multiple key.

However cicumstances exist where for example you have FAMILY NAME, FAMILY MEMBER (2 KEYS are required) but you are using only one as a sort in your request.

In the circumstances that you are looking at, even if you only have 1 key and multiple rows then

1) JOIN ID IN A TO ALL ID IN B (for the join)
2) PRINT X Y Z
BY ID
BY NAME (for the sort)

Will resole your problem

This really is a basic and fundamental issue of any system not just WebFocus.

The forum is a place where those of us using Focus/WebFocus freely give help and advice
but in this case I really do suggest that you request that your employer pay for you to have some basic
training from a competent person.

This message has been edited. Last edited by: <JG>,
 
Report This Post
slfmr
Platinum Member
posted Hide Post
Thank you Texas Stingray... a merge is what I had more in mind. This has helped me!

Umm okay, thank you JG (I think). I was just asking a question, I don't think insults are necessary.

If you were going to just do that, I would have rather you not replied to my post.

Thank you all for your help. I apologize if my questions are too "basic." I too thought that "the forum is a place where those of us using Focus/WebFocus freely give help and advice."

This message has been edited. Last edited by: slfmr,


Dev, SIT, UAT, Production:7.6.6
Dev Sandbox:7.6.11

Dev Studio - 7.6.6
 
Posts: 178 | Registered: May 11, 2005Report 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     Can I Join a File By Columns

Copyright © 1996-2020 Information Builders