06-24-2015 02:49 AM
I have Two datasets as below "primary" and "secondary" :
OBS CJOB HLQ NO1 NO2 NO3 ....
1 JOB1 SMGP 1 2 2
2 JOB2 TEMP 8 8 8
3 JOB3 PERM 9 9 9.
I have a requirement to do lookup from Secondary dataset to Primary dataset and get match output based on either CJOB or HLQ
So from above example Since Secondary dataset as Job1/Job2 and HLQ=TEMP
Output should be Observation 1 and 2
I tried with Index however since Key can be on one unique that doesn't seems to work ..any idea??