Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] combine output with MORE and a DEFINEd field
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] combine output with MORE and a DEFINEd field
 Login/Join
 
Silver Member
posted
I want to combine the output (flat file) of 2 TABLE FILEs. Thus, I’m doing the following:

TABLE FILE table1
WHERE filter
SUM fields
BY fields
ON TABLE SAVE FILENAME file.txt

MORE
FILE table2
WHERE fields
END

The above works fine. However, I want to make a slight change and use a DEFINE’d field instead of a real field in the SUM and BY. Thus, I put a DEFINE above the TABLE FILE and I used the DEFINEd field in the SUM and BY. That works fine if I just have one normal TABLE FILE. But if I want to use the DEFINEd field in the original, combined MORE, I get this error:

(FOC952) NO MATCH IS FOUND FOR THE FIELD OF MAIN REQUEST: REAL_NAME

If I put the DEFINE FILE above both the TABLE FILE table1 and the FILE table2, I get this error:

(FOC001) THE NAME OF THE FILE OR THE WORD 'FILE' IS MISSING

(FOC009) INCOMPLETE REQUEST STATEMENT
BYPASSING TO END OF COMMAND
(FOC1517) UNRECOGNIZED COMMAND FILE FY2019
(FOC1517) UNRECOGNIZED COMMAND WHERE VENDOR_NO GE '1000000000'
(FOC1517) UNRECOGNIZED COMMAND AND AOBJ GE '0101'
(FOC1517) UNRECOGNIZED COMMAND AND AOBJ LE '0220';

Is there a way to combine output using MORE along with a DEFINEd field?

Thanks,
Mark

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


WF 8.2.02
App Studio
DataMigrator
ReportCaster
Windows Server 2016
 
Posts: 32 | Registered: September 08, 2003Reply With QuoteReport This Post
Member
posted Hide Post
I think you need to create your defined field for both table1 and table2. Did you try Something like this :

DEFINE FILE table1
DEF1 =
END
DEFINE FILE table2
DEF1 =
END
Then your TABLE FILE with MORE
 
Posts: 10 | Location: Information Builders France | Registered: May 22, 2003Reply With QuoteReport This Post
Virtuoso
posted Hide Post
When using MORE, all combined files must have the same number of field, same field name/format/length
Sample
TABLE FILE CAR
PRINT RETAIL_COST
BY COUNTRY
BY CAR
BY MODEL
WHERE SEATS EQ 2;
ON TABLE HOLD AS TBL1
END
-RUN

TABLE FILE CAR
PRINT RETAIL_COST
BY COUNTRY
BY CAR
BY MODEL
WHERE MODEL CONTAINS '2 DOOR';
ON TABLE HOLD AS TBL2
END
-RUN

DEFINE FILE TBL1
FLD /A10V = 'TABLE 1';
END
DEFINE FILE TBL2
FLD /A10V = 'TABLE 2';
END
TABLE FILE TBL1
PRINT RETAIL_COST
BY FLD
BY COUNTRY
BY CAR
BY MODEL
MORE
FILE TBL2
END
-RUN


WF versions : Prod 8.2.0.1M gen 240, Dev 8.2.04 gen 48, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2159 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Reply With QuoteReport This Post
Silver Member
posted Hide Post
Jean-Claude and Martin,

Thanks for both of your replies. I went with the first, and simpler one. I moved the 2nd DEFINE right under the first DEFINE and before the (first) TABLE FILE and it worked.

Thanks again.

Mark


WF 8.2.02
App Studio
DataMigrator
ReportCaster
Windows Server 2016
 
Posts: 32 | Registered: September 08, 2003Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] combine output with MORE and a DEFINEd field

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.