View previous topic :: View next topic |
Author |
Message |
davinski.bby Beginner
Joined: 30 Jul 2007 Posts: 31 Topics: 10
|
Posted: Mon Aug 13, 2007 8:19 pm Post subject: Extracting records from 2 files |
|
|
Hi,
I have 2 datasets. d1 and d2. i need to get all records in d2 that has the same value in a certain column in d1.
The two files are of different record length.
File1 = 300
File2 = 200
NAME PICX(5)
GRADE PICX(2)
here is an example:
dataset1
Code: |
GRADE SECTION
A1 DIAMOND
A2 RUBY
C3 JADE
|
dataset2 Code: |
NAME GRADE
JOE A1
JOHN A1
JACK A1
JEN B7
JES C3
MAR C3
TIN A2
CRIS D8
|
OUTPUT WOULD BE
Code: |
NAME GRADE
JOE A1
JOHN A1
JACK A1
JES C3
MAR C3
TIN A2
|
Thanks. |
|
Back to top |
|
 |
kolusu Site Admin

Joined: 26 Nov 2002 Posts: 12377 Topics: 75 Location: San Jose
|
|
Back to top |
|
 |
|
|