Is Lookup possible irrespective of matching key?
Posted: Tue Oct 26, 2004 10:26 am
I was just wondering if there is any way where I can have a lookup irrespective of what the hashfile key field is looked up against. In other words can I look up a hash File for a particular field(say to be used in transformer) in all circumstances and have that for manipulation of all the incoming streaming records from other link.
Basically it started like this.I have a simple rule something like 'Cost A/sum of all Costs A*100).In essence,I've to find % contribution of each cost against all. I tried using something like this
FlatFile-->Aggregator------------>HashFile
|Lkup
|
Copyof_FlatFile-->Trans1------->Trans2
|
|
Output File
And I wanted to lookup against the hashFile always where I'm collecting the sum of all CostsA; then I could have used it in Trans2. There is no 'primary key' in the source input file.
I'm stumped!
Any answer for my Q. Or any better idea to do this otherwise simple looking thing in one job. Another way is to break up this into two jobs/b4 subroutine and use the output from there as input for this job.
Basically it started like this.I have a simple rule something like 'Cost A/sum of all Costs A*100).In essence,I've to find % contribution of each cost against all. I tried using something like this
FlatFile-->Aggregator------------>HashFile
|Lkup
|
Copyof_FlatFile-->Trans1------->Trans2
|
|
Output File
And I wanted to lookup against the hashFile always where I'm collecting the sum of all CostsA; then I could have used it in Trans2. There is no 'primary key' in the source input file.
I'm stumped!
![Rolling Eyes :roll:](./images/smilies/icon_rolleyes.gif)