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] Is there a way to UNION hold files?

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] Is there a way to UNION hold files?
 Login/Join
 
DParks
Member
posted
Here's the problem that I'm trying to solve. Imagine records with the following format:

PRid, Approver1, ApprovedDate1, Approver2, ApprovedDate2

With the following records:

123, Fred, 2010, Joe, 2010
890, Mary, null, Sue, 2011

What I'd like is a report like this:

PRid Approver Num Date
123  Fred     1   2010
123  Joe      2   2010
890  Mary     1   null
890  Sue      2   2011


The way I was trying to solve it was to create a hold file for all Approver1's and another for all Approver2's and then to UNION the hold files. But I can't find any way to do a UNION in INFOassist.

Thanks for any help!

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


WebFOCUS 8
 
Posts: 2 | Registered: June 17, 2014Report This Post
Waz
Expert
posted Hide Post
Hi DParks, welcome to the forum.

There are several ways to do this. Your initial thoughts are probably the easiest to follow.

You can use the APPEND command with the FILEDEF command to add records to a hold file.

e.g.
EX -LINES * EDAPUT MASTER,SOMEDATA,CV,FILE
FILENAME=SOMEDATA, SUFFIX=COM,$
SEGNAME=SOMEDATA, $
  FIELD=PRid          ,ALIAS=  ,I9   ,A9 ,$
  FIELD=Approver1     ,ALIAS=  ,A10 ,A10 ,$
  FIELD=ApprovedDate1 ,ALIAS=  ,YY  ,A4  ,$
  FIELD=Approver2     ,ALIAS=  ,A10 ,A10 ,$
  FIELD=ApprovedDate2 ,ALIAS=  ,YY  ,A4  ,$
EDAPUT*

EX -LINES * EDAPUT FOCTEMP,SOMEDATA,CV,FILE
123, Fred, 2010, Joe, 2010
890, Mary,., Sue, 2011
EDAPUT*

FILEDEF SOMEDATA DISK somedata.ftm (RECFM V LRECL 80

SET PCOMMA=ON

-RUN

TABLE FILE SOMEDATA
PRINT
PRid
Approver1
ApprovedDate1
COMPUTE NUMB/I9 = 1 ;
ON TABLE HOLD AS TEMPDATA FORMAT ALPHA
END

FILEDEF TEMPDATA DISK tempdata.ftm (APPEND

TABLE FILE SOMEDATA
PRINT
PRid
Approver2
ApprovedDate2
COMPUTE NUMB/I9 = 2 ;
ON TABLE SAVE AS TEMPDATA
END

-RUN

FILEDEF TEMPDATA DISK tempdata.ftm

-RUN

TABLE FILE TEMPDATA
PRINT
PRid
Approver1
ApprovedDate1
NUMB
END


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
DParks
Member
posted Hide Post
Okay, so I'm not such an experienced user. Where within the INFOassist application does one do this type of coding? Can you do it through the INFOassist client or is it required to have server access? The only place where I'm familiar with any type of coding is the the Data tab using the Detail (Define) and Summary (Compute) functions.


WebFOCUS 8
 
Posts: 2 | Registered: June 17, 2014Report This Post
Tamra
Guru
posted Hide Post
Hi Dparks,

Welcome to Focal Point!

Since as you indicate you are fairly new to WebFOCUS may I suggest opening a case with Information Builders technical support – at InfoResponse - https://techsupport.informationbuilders.com/ .

The suggestion provided is a bit more detailed and needs to be entered into the editor. A Technical Support Representative can assist you with this once a case has been opened. You can also call into the Helpdesk to open a case at 1-800-736-6130.

Here is a link that will help with creating a HOLD file within InfoAssist.
https://techsupport.informatio...om/sps/10833019.html (you will need to log into the Techsupport site - link above)

Please keep us posted on the final solution from your case. Thank you in advance for sharing with all.

Thank you,
Tamra Colangelo
Information Builders Customer Support


WebFOCUS 8x - BI Portal, Developer Studio, App Studio, Excel, PDF, Active Formats and HTML5
 
Posts: 487 | Location: Toronto | Registered: June 23, 2009Report 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] Is there a way to UNION hold files?

Copyright © 1996-2020 Information Builders