Search found 31 matches
- Thu Jul 22, 2004 9:48 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Hash Lookup to get the Exact Date
- Replies: 1
- Views: 651
Hash Lookup to get the Exact Date
I created a hash file implementing some logic and managed to get the data using a where clause in the input to get all the records where RR=0 into a hash file. If it gets two records with the same data it will merge into one with a delimeter ID Name zip Date 1 RR 1121 12/20/2001 2 CC 1122 05/04/2002...