[CLOSED] Compare two columns from two different tables
Hi All,
I want to know that is there any technique in Webfocus where I can compare two columns form different hold files?
For Eg.
DEFINE FILE MAIN1 ID NAME
DEFINE FILE MAIN2 MARKS
I want to print marks of file MAIN2 based on the ids in MAIN1.
Thank you for the help.This message has been edited. Last edited by: Kerry,
Webfocus 7.7.03 Windows XP Excel, PDF, HTML, APDF, AHTML, Maintain
September 14, 2009, 07:00 AM
<JG>
JOIN or MATCH
Read the docs.
September 14, 2009, 07:44 AM
SureshKumar
TABLE FILE EMPLOYEE PRINT COMPUTE BREAKX/I2 = 1; LAST_NAME FIRST_NAME ON TABLE HOLD AS H1 END TABLE FILE EMPLOYEE PRINT COMPUTE BREAKX/I2 = 2; DEPARTMENT ON TABLE HOLD AS H2 END -RUN -* MATCH FILE H1 PRINT LAST_NAME FIRST_NAME BY BREAKX RUN FILE H2 PRINT DEPARTMENT BY BREAKX AFTER MATCH HOLD OLD-OR-NEW END -RUN[/CODE]