 |
|||||
|
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 |
| -INCLUDE or MATCH or something | Login/Join |
| Gold member |
I am wondering if either MATCH or -INCLUDE will help me accomplish something a little tricky. I would like to create an Excel report that has different pieces of data on each row across date quarters. For instance: Q1 Q2 Q3 Q4 Acct Type 1 Acct Type 2 All Closed The first two rows would be spread out by quarter based on when it was opened. The 3rd row is based on when an account was closed. Since I can't seem to come up with a GROUP BY statement, I figure I might have to run separate reports and sort of stack them on top of each other. Again, row three is a subset of rows one or two but based on the date closed. Thanks to all. I'm new to the INCLUDE and MATCH uses. WF (App Studio) 8.2.01m / Windows Mainframe FOCUS 8 | ||
|
| Virtuoso |
I would probably do the stack multiple report queries route. Example. "There is no limit to what you can achieve ... if you don’t care who gets the credit." Roger Abbott | |||
|
| Virtuoso |
Bob I would think of FML, that has the ability to get the same data into different rows.
| |||||||
|
| Master |
Is your data in multiple files? What is the format of the data? This may be as simple as: TABLE FILE FILEX SUM CNT.FIELDA ACROSS QUARTER BY DATATYPE END Pat WF 7.6.8, AIX, AS400, NT AS400 FOCUS, AIX FOCUS, Oracle, DB2, JDE, Lotus Notes | |||
|
| Gold member |
Thanks dhagen. I actually used the MATCH FILE in the example link you sent. Could not figure out the FILEDEF...FML suggestion. Now if I could figure out how to customize the field title at each sort break, that would be perfect. Conditional formatting for SKIP-LINE does not work when using Excel as PCHOLD format. Thanks to all. WF (App Studio) 8.2.01m / Windows Mainframe FOCUS 8 | |||
|
| Virtuoso |
What do you want the field title to do?
| |||||
|
| 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 |