I have two files (Seq1 & seq2) and need to compare two file with column name policy.
Seq File1
Policy_no
Type
Seq File2
Policy_no
I am comparing both policy_no and if matched then type should be XX Else YY. I am doing this logic (col1=col2 then xx else yy) in transformer and defining the logic in column Type but I am not getting correct results.
Any advice will be very much helpful.
Comparing two files
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 46
- Joined: Fri May 02, 2008 1:11 am
- Location: Chennai
Comparing two files
Vignesh Kumar N
-
- Participant
- Posts: 46
- Joined: Fri May 02, 2008 1:11 am
- Location: Chennai
Comparing two files
Yes it is server job.
Small change in design. It is not seq file instead it is hashed file.
hash 1 & 2 -> Transformer->hash file
Small change in design. It is not seq file instead it is hashed file.
hash 1 & 2 -> Transformer->hash file
Vignesh Kumar N
OK, so off we go to the Server forum.
Since a transformer can't have two stream inputs, how are you bringing them in? HF1 is the stream input and HF2 is a reference input? Can we assume that 'policy number' is the key field in both hashed files and your reference lookup is based on that key? Please let us know if I've gotten anything wrong.
ps. Saying that you are "not getting correct results" doesn't really help us help you. What results are you getting? What's not working about whatever it is you are doing?
Since a transformer can't have two stream inputs, how are you bringing them in? HF1 is the stream input and HF2 is a reference input? Can we assume that 'policy number' is the key field in both hashed files and your reference lookup is based on that key? Please let us know if I've gotten anything wrong.
ps. Saying that you are "not getting correct results" doesn't really help us help you. What results are you getting? What's not working about whatever it is you are doing?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers