Null 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: ...
Forum Discussion
Hi @Damone
Did you try using string concatenation using ‘+’ ?
$STREET+‘,’+$CITY+‘,’+$STATE+‘,’+$ZIP+‘,’+$COUNTRY
testCom_2022_06_14.slp (3.7 KB)
Regards,
Ajay
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.Hi @Damone
you need null value or empty or blank value for those null?Regards,
AjayGood morning Ajay,
I’d prefer to keep them as null values.
