how to avoid duplicate listing????

Focal Point

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/8401026472

March 05, 2008, 04:45 AM

rb4u

how to avoid duplicate listing????

Hi all,
I encounter a problem like this,

i have to match 2 files, where 1 file contain only one field but the other file contains many match listing.

file1 file2
------ ------
151000 151000
151000
151000
151000
151000
151000
151000
151000
151000
151000
151000.......

so how to match these two files (MFD's) with out duplicate values.

Focus Core 7.1.1 & 7.6.4
XP
MainFrames

March 05, 2008, 09:10 AM

GinnyJakes

Do a join instead of a match. Then do a sum on the column in file 1.

Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google

March 06, 2008, 09:59 AM

PBrightwell

Or do a SUM COL1 NOPRINT BY COL1 on the file with multiple entries before you do the match.

Pat
WF 7.6.8, AIX, AS400, NT
AS400 FOCUS, AIX FOCUS,
Oracle, DB2, JDE, Lotus Notes