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     [SOLVED] concatenating Tables

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] concatenating Tables
 Login/Join
 
ChristianP
Platinum Member
posted
Hi,
in my fex i have 3 alpha files and i want to bring them together in one table. The first two files have only one value, and i want to place them on the first two places as constants. The third alpha has the main data.

Alpha1 Aplha2 Alpha3
Q42010/11 100100 1. TRANSPORTKOSTEN INBOUND 111.000
Q42010/11 100100 1.1. SCHIENE 0
Q42010/11 100100 1.2. STRASSE 0
Q42010/11 100100 1.2.1. LKW - Nahverkehr 0
Q42010/11 100100 1.2.2. LKW - Fernverkehr 0
Q42010/11 100100 1.2.2.1. LKW - Fernverkehr National 0

Regards

Christian

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


WF Production Version: 7.7.02M
WF Test Version: 7.7.02M
Developer Studio: 7.7.02
HTML, EXL2K, FLEX, PDF,PPT
 
Posts: 156 | Location: Essen Germany | Registered: December 02, 2010Report This Post
njsden
Virtuoso
posted Hide Post
So you're not really "concatenating" tables.

What you need is to JOIN them *if* there is any value in ALPHA3 you can use to join to ALPHA1 and ALPHA2.

If you don't have such a value, you could make it up using a DEFINE-based JOIN.

A perhaps simpler approach would be to -READ each value from ALPHA1 and ALPHA2 into a couple of &variables.

Then, DEFINE 2 fields in ALPHA3 giving each the value of each &variable you read above.

Now you'll have everything there.

-READ ALPHA1 &ALPHA1_VAL.A9.
-READ ALPHA2 &ALPHA2_VAL.A6.

DEFINE FILE ALPHA3
ALPHA1_KEY/A9 = '&ALPHA1_VAL';   <=== 'Q42010/11'
ALPHA2_KEY/A6 = '&ALPHA2_VAL';   <=== '100100'
END

TABLE FILE ALPHA3
PRINT ALPHA1_KEY
      ALPHA2_KEY
      ALPHA3.FIELD1
      ALPHA3.FIELD2
      ...
END


quote:
The first two files have only one value


That approach I suggested should work based on your statement above, which I interpret as: ALPHA1 and ALPHA2 have *1* record/line each.

Hope that helps.


Prod/Dev: WF Server 8008/Win 2008 - WF Client 8008/Win 2008 - Dev. Studio: 8008/Windows 7 - DBMS: Oracle 11g Rel 2
Test: Dev. Studio 8008 /Windows 7 (Local) Output:HTML, EXL2K.
 
Posts: 1533 | Registered: August 12, 2005Report This Post
ChristianP
Platinum Member
posted Hide Post
Hi njsden,
perfect!!!!! The problem with webfocus is that nearly everything is possible and our internal costumer knows that!!!

Regards

Christian


WF Production Version: 7.7.02M
WF Test Version: 7.7.02M
Developer Studio: 7.7.02
HTML, EXL2K, FLEX, PDF,PPT
 
Posts: 156 | Location: Essen Germany | Registered: December 02, 2010Report This Post
njsden
Virtuoso
posted Hide Post
Glad it helped! I like customers like that ... challenging yet reasonable (I hope the latter applies to yours Wink ).

Would you please prefix your original post's title with [SOLVED]?

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


Prod/Dev: WF Server 8008/Win 2008 - WF Client 8008/Win 2008 - Dev. Studio: 8008/Windows 7 - DBMS: Oracle 11g Rel 2
Test: Dev. Studio 8008 /Windows 7 (Local) Output:HTML, EXL2K.
 
Posts: 1533 | Registered: August 12, 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     [SOLVED] concatenating Tables

Copyright © 1996-2020 Information Builders