If you wanted this to be a true JOIN file, you would have to separate out the address information from CustFL and put it in a special record in ShipTo (perhaps with a Ship# of zero?). This is an example of a normalized database, where common information is stored in a single file. The problem is that in your case, you have address information in two different files. If you don't want to change how your data is stored, you need to have a UNION, which includes records from BOTH files. You can do that with a multi-format logical file. Joe
Unconfigured Ad Widget
Collapse
Announcement
Collapse
No announcement yet.
Join Logical File
Collapse
X
-
Join Logical File
Subject: Join Logical FileHi, everyone. I need some help with Join LF. I have 2 files: CustFL and ShipTo Data Example for CustFL: Cust# Name City St 0324600 ABC SHOP PHILA PA Data Example for CustFL: Cust# Ship# Name City St 0324600 001 ABC SHOP New York NY 0324600 002 ABC SHOP Trenton NJ I want to join them, so I can pull all the records from both files into Join LF(CUSTALL). Cust# Ship# Name City St 0324600 ABC SHOP PHILA PA 0324600 001 ABC SHOP New York NY 0324600 002 ABC SHOP Trenton NJ I created JLF below: A JDFTVAL A R CUSTFMT JFILE(CUSTFL SHIPFL) A J JOIN(CUSTFL SHIPFL) A JFLD(ARDIV DIV) A JFLD(CUST# CUST#) A ADIV JREF(CUSTFL) A RENAME(DIV) A ACUST# JREF(SHIPFL) A RENAME(CUST#) A ASHIP# JREF(SHIPFL) A RENAME(SHIP#) A*= A* Key Field(s): A*= A K ADIV A K ACUST# This File only pulling: Cust# Ship# Name City St 0324600 001 ABC SHOP New York NY 0324600 002 ABC SHOP Trenton NJ What am I doing wrong ? I already tried everything I could think off. Thanks in advance. Gary
Comment