Lookup not matching
Moderators: chulett, rschirm, roy
Lookup not matching
I have a source Hashed file
ex:
No1(key) No2 no3
100~8~T 205
100~9~T 305 405
I need to perform a look up against the same hashed file.
So i created a new hashed file from the source and split the key into
Noa(Key) Nob(Key) Noc(Key) No2 no3
100 8 T 205
100 9 T 305 405
Now i am performing a lookup.
when ever there is a match on 100~8~T then i need to have the same value 205 in 100~9~T(no3) so that my output should look like
ex:
No1(key) No2 no3
100~8~T 205
100~9~T 305 205(Changed from 405 to 205)
Any advice
Thanks in advance
** Note: Subject changed to be more descriptive - Content Editor**
ex:
No1(key) No2 no3
100~8~T 205
100~9~T 305 405
I need to perform a look up against the same hashed file.
So i created a new hashed file from the source and split the key into
Noa(Key) Nob(Key) Noc(Key) No2 no3
100 8 T 205
100 9 T 305 405
Now i am performing a lookup.
when ever there is a match on 100~8~T then i need to have the same value 205 in 100~9~T(no3) so that my output should look like
ex:
No1(key) No2 no3
100~8~T 205
100~9~T 305 205(Changed from 405 to 205)
Any advice
Thanks in advance
** Note: Subject changed to be more descriptive - Content Editor**
satya
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
When i find a match on 100~8~T then i need to use value in no2 column i.e 205 and drop it in no3 column of 100~9~t(cross reference)
No1(key) No2 no3
100~8~T 205
100~9~T 305 405
Noa(Key) Nob(Key) Noc(Key) No2 no3
100 8 T 205
100 9 T 305 405
o/p
No1(key) No2 no3
100~8~T 205
100~9~T 305 205(Changed from 405 to 205)
No1(key) No2 no3
100~8~T 205
100~9~T 305 405
Noa(Key) Nob(Key) Noc(Key) No2 no3
100 8 T 205
100 9 T 305 405
o/p
No1(key) No2 no3
100~8~T 205
100~9~T 305 205(Changed from 405 to 205)
satya
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Yeah. I understood that and provided the solution.
Code: Select all
If RefLink.NOTFOUND Then InputLink.TheValue Else RefLink.TheValue
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 597
- Joined: Fri Apr 29, 2005 6:19 am
- Location: Singapore
Yes, can you please provide examples of what you get from the lookup (the unexpected result) and examples of what your "expected result" would be in that case. Also, "View Data" on your hashed file and ensure that it looks like you've built it properly - as expected. Click inside the key values in the browser to ensure there's nothing tripping you up like trailing spaces there rather than in your incoming data.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 597
- Joined: Fri Apr 29, 2005 6:19 am
- Location: Singapore
Satya, To be more precise...
Your source hash file (1 file) contains data like this
100~8~T 205
100~9~T 305 405
200~7~T 101
200~9~T 201 202
And you want output like shown below in one target file?
100~8~T 205
100~9~T 305 205
200~7~T 101
200~9~T 201 101
So you are using the first part (100 or 200) to differentiate the combination?
Your source hash file (1 file) contains data like this
100~8~T 205
100~9~T 305 405
200~7~T 101
200~9~T 201 202
And you want output like shown below in one target file?
100~8~T 205
100~9~T 305 205
200~7~T 101
200~9~T 201 101
So you are using the first part (100 or 200) to differentiate the combination?
Kandy
_________________
Try and Try again…You will succeed atlast!!
_________________
Try and Try again…You will succeed atlast!!