Damone
New Contributor
Joined 8 years ago
User Profile
User Widgets
Contributions
Re: How to Create a SQL Server Connected Lookup
Thank you. That is definitely useful and I will go that route going forward. In this instance, one important thing that I forgot to mention is that my source is Oracle DB, and my target and lookup tables are in SQL Server. So I am selecting from Oracle, checking a SS table to see if the attribute exists, and if not, then insert / update.3.7KViews0likes1CommentHow to Create a SQL Server Connected Lookup
I need to mimic Informatica’s simple connected lookup process. I want to look for a record on a target table and if it exists, update it, otherwise insert it. I have tried to use the Lookup Snap, but I haven’t been able to make it work for me. Does someone have an example or a pattern that I can see?Solved5.4KViews0likes5CommentsRe: Null Values Not Written to Table
Hello, Thank you for your response. Unfortunately, that isn’t working either. Oddly enough, it actually writes ‘null’ out onto the table. I’ve been tweaking your expression, and I get close but keep hitting a wall. I think I’ll skip trying to use an expression and load the table using sql.2.5KViews0likes2CommentsNull Values Not Written to Table
My Oracle input is address information similar to: STREET: 123 MAIN STREET CITY: ANYTOWN STATE: ANYSTATE ZIP: 12345 COUNTRY: USA STREET: null CITY: OTHERTOWN STATE: OTHERSTATE ZIP: 54321 COUNTRY: CAN STREET: null CITY: OTHERTOWN STATE: null ZIP: null COUNTRY: USA My desired output would be as follows: 123 MAIN STREET, ANYTOWN, ANYSTATE 12345 USA null, OTHERTOWN, OTHERSTATE, 54321 CAN null, OTHERTOWN, null null USA My problem occurs when ‘STREET’ (the first value) is null. In that case, my entire record gets written as null. 123 MAIN STREET, ANYTOWN, ANYSTATE 12345 USA null null I have used variations of this expression, all without success. $STREET.concat(", ", $CITY, ", " , $STATE , " “,$ZIP,” ",$COUNTRY) $STREET==null?‘’:$STREET.concat(", ", $CITY, ", “, $STATE”, “, :$ZIP”, ", $COUNTRY) $STREET1==null?‘’:$STREET1.concat(“, “, $CITY==null?‘-’:$CITY”).concat(”, “, $STATE==null?‘-’:$STATE”) … Any help figuring this out is appreciated.