 |
|||||
|
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 |
| Compound CSV | Login/Join |
| Platinum Member |
I need to generate a report whose output format is compound csv.Csv for a single table output works fine .But i am not able to generate Compund CSV. Thanks in Advance WebFOCUS 7610 Windows | ||
|
| Expert |
Could you please update your signature with the version and platform of WebFOCUS that you're working with? Compound reports are for output types that actually create reports, like HTML PDF and EXL2K, not for formats that create files, like ALPHA, CSV, etc. What are you trying to combine together? Is it's two files with the same fields and formats, try looking into the MORE command. Francis  Give me code, or give me retirement. In FOCUS since 1991 Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server | |||
|
| Platinum Member |
Hi Francis Yes we trying to combine two files. But those files have different fields and formats.I am trying to generate this file from a compound html output. please let me know is it possible.... WebFOCUS 7610 Windows | |||
|
| Virtuoso |
HTML is something else. a compund report made out of two files with different field formats and layout ?? Who wants to get something like that.
| |||||||
|
| Master |
are you talking about creating an Excel output with your csv that is multiple tabs? what you're asking for doesn't make sense if I understand it correctly. If you have two comma-delimited outputs that you want to put on the same html layout, you're doing something very...different. Let us know what you want your result to be and maybe one of us can help. Thanks. Prod: Single Windows 2008 Server running Webfocus 7.7.03 Reporting server Web server IIS6/Tomcat, AS400 DB2 database. | |||
|
| Platinum Member |
CSV is a pretty simple format ... two get two answer sets in one file ... A MATCH on a dummy key will work too. APP FI FRED DISK WILMA/FRED.CSV (LRECL 500 RECFM V TABLE FILE CAR SUM DC RC BY COUNTRY ON TABLE HOLD AS FRED FORMAT COM END APP FI FRED DISK WILMA/FRED.CSV (LRECL 500 RECFM V APPEND TABLE FILE CAR SUM DC RC BY CAR ON TABLE HOLD AS FRED FORMAT COM END Brian Suter VP WebFOCUS Product Development | |||
|
| Platinum Member |
Hi Brain ... It is working fine... How do we differenciate file1 and file2 WebFOCUS 7610 Windows | |||
|
| Master |
I would define a record type. DEFINE FILE CAR REC_TYPE/A1='1'; END APP FI FRED DISK WILMA/FRED.CSV (LRECL 500 RECFM V TABLE FILE CAR SUM REC_TYPE DC RC BY COUNTRY ON TABLE HOLD AS FRED FORMAT COM END APP FI FRED DISK WILMA/FRED.CSV (LRECL 500 RECFM V APPEND DEFINE FILE CAR REC_TYPE/A1='2'; END TABLE FILE CAR SUM REC_TYPE DC RC BY CAR ON TABLE HOLD AS FRED FORMAT COM END Pat WF 7.6.8, AIX, AS400, NT AS400 FOCUS, AIX FOCUS, Oracle, DB2, JDE, Lotus Notes | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicCopyright © 1996-2020 Information Builders
| 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 |