Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

how to avoid null values in dynamic lookup

Status
Not open for further replies.

vikind

MIS
Dec 11, 2003
58
US
hi,

this is simple but i am stuck..
i am doing a dynamic lookup on my target..but for some reason
null value gets inserted into the target table..

like in my source if i have IN_POS_ID is null and in the lookup i have a condition

IN_POS_ID = POS_ID. I do not want to insert records where the POS_ID is null but it still gets

inserted into the target table..i used a Router and update strategy after my lookup for insert and updates.

in lookup but still a null record gets inserted ..

thanks for ur help!
 
How about a Filter Trans to discard the Null values from POSID field????

Sri
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top