Hi ,
I have a doubt regarding the NOTFOUND condition.
My job looks like
lukup(OLEDB)
|
|
V
FILE ----> Transformer -------> FILE
My requirement is if lukup found means populate the looked up valuee else populate input value
I gave the condiotion if link.NOTFOUND = 0 THEN lookedupvalue else input value
I'm not gettingthe desired result. i.e If the look up doesn't have matching value means it is populating spaces.If look up returns means it is populating the looked up value.
Am i missing anything here ? What should i do to get the input value in case of look up not neturning value.The same situation works fine with ODBC look up.
NOT FOUND CONDITION
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 90
- Joined: Mon Dec 08, 2003 4:48 am
- Location: Chennai
NOT FOUND CONDITION
Think Ahead,
Raj.D
Raj.D
-
- Participant
- Posts: 90
- Joined: Mon Dec 08, 2003 4:48 am
- Location: Chennai
the look up should point to the transformer
oops ! !!!!!!!!
the look up should point to the transformer
the look up should point to the transformer
Think Ahead,
Raj.D
Raj.D
As far as I know, these are boolean values and not meant to be used in quite the way you are using them. You should simply say:
I'm not sure what you mean about the spaces, but give it a shot like this and see how that works for you.
I remember (back in the day) when these variables were first introduced - they didn't always work correctly.
We backed off from them and went back to the 'old way' of checking for nulls in a lookup key and I've never really used them since. For whatever that is worth. ![Laughing :lol:](./images/smilies/icon_lol.gif)
Code: Select all
if link.NOTFOUND Then input value Else lookedup value
I remember (back in the day) when these variables were first introduced - they didn't always work correctly.
![Confused :?](./images/smilies/icon_confused.gif)
![Laughing :lol:](./images/smilies/icon_lol.gif)
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Premium Member
- Posts: 224
- Joined: Tue Sep 24, 2002 7:32 am
- Location: Denver, CO USA