Search found 3 matches

by ragsara
Mon Mar 26, 2012 6:36 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: DFSORT - JOINKEYS
Replies: 7
Views: 8884

Hi Yaeger, Apologise for not providing you the complete requirement at the first look. Here is an example of my requiremnet. File1 : Record 1: 1-75 (KEY) 76-521 (DATA) File2 : Record 1: 1-75 (KEY) 76 (P) 77-277(DATA) Record 2: 1-75 (KEY) 76 (M) 77-277(DATA) Output file Record 1 : 1-75 (KEY File1) 76...
by ragsara
Fri Mar 23, 2012 2:38 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: DFSORT - JOINKEYS
Replies: 7
Views: 8884

Thanks Frank, Why i have decided to go for for Join keys is for the following reason, File1 - 520 (first 75 key) File2 - 250 (First 75 key) I need to evaluate 76th position in File 2, to see if its P or M . Based on this i need to evaluate File1 and File2, here are the scenarios which i need to hand...
by ragsara
Thu Mar 22, 2012 6:16 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: DFSORT - JOINKEYS
Replies: 7
Views: 8884

DFSORT - JOINKEYS

Hi I am trying to join File F1 and File 2 with keys in position 1 to 75 in both the files. A key in in F1 contains two matching records in F2. Normally when we perform join two records gets written into the output file. But according to my requirement, I need only one record in the output. However, ...