DEFINE FILE CAR
COUNTRYN/A10 = COUNTRY
END
TABLE FILE CAR
PRINT MODEL CAR
WHERE COUNTRY EQ 'ENGLAND' AND CAR EQ 'JENSEN'
BY COUNTRYN
ON TABLE HOLD AS HOLD1
END
-RUN
MATCH FILE HOLD1
PRINT MODEL CAR BY COUNTRYN
RUN
FILE CAR
PRINT COUNTRY COUNTRY CAR MODEL BODYTYPE  BY COUNTRY
AFTER MATCH HOLD AS CARHOLD OLD-OR-NEW
END
-RUN
TABLE FILE CARHOLD
PRINT *
END

quote:

Using Sort Fields in MATCH Requests
If the data sources in the MATCH share common high-order sort fields with identical names and formats, the MATCH process merges records with matching sort field values from each of the files. If the two data sources in the MATCH have the same sort field with different names, you can change one of the names with an AS phrase .

If the files in the MATCH do not share a high-order sort field, the fields are not compared. Instead, the fields from the first record in each data source are merged to create the first record in the HOLD file, and so on for all remaining records.

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

SET HOLDLIST=PRINTONLY
SET HOLDFORMAT=ALPHA
TABLE FILE CAR
PRINT MODEL CAR BODYTYPE
WHERE COUNTRY EQ 'ENGLAND' OR COUNTRY EQ 'JAPAN' 
BY COUNTRY
ON TABLE HOLD AS HOLD1
END
-RUN

TABLE FILE CAR
PRINT MODEL CAR BODYTYPE
WHERE COUNTRY EQ 'ENGLAND' OR COUNTRY EQ 'ITALY' 
BY COUNTRY
ON TABLE HOLD AS HOLD2
END
-RUN

TABLE FILE HOLD1
PRINT *
MORE
FILE HOLD2
END

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

DEFINE FILE CAR
COUNTRYN/A10 = COUNTRY
END
TABLE FILE CAR
PRINT MODEL
      CAR
WHERE COUNTRY EQ 'ENGLAND' AND CAR EQ 'JENSEN'
BY COUNTRYN
ON TABLE HOLD AS HOLD1
END
-RUN
MATCH FILE HOLD1
SUM   MODEL
      CAR
BY COUNTRYN AS COUNTRY
RUN
FILE CAR
PRINT
      BODYTYPE
BY COUNTRY
BY CAR
BY MODEL
BY BODYTYPE
AFTER MATCH HOLD AS CARHOLD OLD-OR-NEW
END
-RUN
TABLE FILE CARHOLD
PRINT *
END

Waz...

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

quote:

Thanks guys.. I got this issue resolved.

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