Join issue
Posted: Wed Oct 28, 2009 2:21 pm
Hi All,
I am trying to join 2 files based on key1(int) and key2(varchar), its not finding a match when I use both as keys although I can manually see the file and finds a match. if I remove key2 its working on Key1 but key2 is required. I tried trimming both keys in both files but still no match. Both files are generated from oracle table and I have $apt_oracle_preserve_blanks as false. I tried both lookup and join with sort, still not working.
Can any one help me on this..
Thanks in advance
I am trying to join 2 files based on key1(int) and key2(varchar), its not finding a match when I use both as keys although I can manually see the file and finds a match. if I remove key2 its working on Key1 but key2 is required. I tried trimming both keys in both files but still no match. Both files are generated from oracle table and I have $apt_oracle_preserve_blanks as false. I tried both lookup and join with sort, still not working.
Can any one help me on this..
Thanks in advance