I have one input file of only one coulmn say "single_column" around 30000 length.It has around 1000 rows each identified by a unique key.
I'm using a hash lookup file as a reference which contains the keys, it has around 400 rows.My job ran successfully but there are no rows coming from the hash file.So, my output file has zero rows.
I checked the data also, it's present in hash files but still it's not matching.
The key expression have given for lookup as
Hash.Key----->SeqFile.single_column[1285,10]
And i'm writing a constraint as Not(Hash.NOTFOUND) then pass the rows otherwise...
Please help me out..
Hash file not matching
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 78
- Joined: Fri Mar 02, 2007 4:54 am
- Location: CHENNAI
-
- Premium Member
- Posts: 273
- Joined: Wed Oct 18, 2006 12:20 pm
- Location: Porto
While writing the Hashed file use TRIM function to remove any extra spaces from left and right.. atleast for the key fields.
While writing the Key Expression, use TRIM function in the same manner... so your key expression would be...
HTH ![Smile :)](./images/smilies/icon_smile.gif)
While writing the Key Expression, use TRIM function in the same manner... so your key expression would be...
Code: Select all
TRIM(SeqFile.single_column[1285,10],'','B').
![Smile :)](./images/smilies/icon_smile.gif)
Share to Learn, and Learn to Share.
-
- Participant
- Posts: 78
- Joined: Fri Mar 02, 2007 4:54 am
- Location: CHENNAI