Hi pals,
I am trying to do look up for masterdataset & update set (Both seq files) AND gave a reject link (peek )to merge.
M_DATA:
S_ID,FNAME,LNAME
1,MAHESH,VUPPALA
2,AVINASH,YEDULLA
3,VAMSHI,ANIMALLA
4,PRADEEP,VEJ
5,mark,john
7,A,B
uPDATE_DATA:
S_ID,MARKS,GRADE
1,90,A
2,75,B
3,60,C
4,40,D
7,50,E
6,30,F
OUTPUT :
"1","MAHESH","VUPPALA" ;,90,"A"
"2","AVINASH","YEDULLA&quo t;,75,"B"
"3","VAMSHI","ANIMALLA&quo t;,60,"C"
"4","PRADEEP","VEJ",4 0,"D"
"5","mark","john",0,& quot;"
"7","A","B",50," E"
Rejected row:
Peek_7,0: S_ID:6 MARKS:30 GRADE:F
error showed:
Merge_0,0: Master record (4) has no updates
Merge_0,0: Update record (4) of data set 1 rejected (no master record)
Is this relates to options in merge :
warn on reject updates &unmatched masters ..false
Please clarify this issue
thanks..
Warning message in Merge stage ?
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 57
- Joined: Tue Jun 30, 2009 9:38 am