BusinessObjects Board

DS 4.1: concat creating nulls

dataservices data quality
#1

With this code

"21359_CHECKNUM_APPEND".PRIMARY_NUMBER_BEST_DELIVERY_COMPONENT || ' ' || 
"21359_CHECKNUM_APPEND".PRIMARY_PREFIX1_BEST_DELIVERY_COMPONENT || ' ' ||
"21359_CHECKNUM_APPEND".PRIMARY_NAME1_BEST_DELIVERY_COMPONENT || ' ' || 
"21359_CHECKNUM_APPEND".PRIMARY_POSTFIX1_BEST_DELIVERY_COMPONENT || ' ' || 
"21359_CHECKNUM_APPEND".PRIMARY_TYPE1_BEST_DELIVERY_COMPONENT

if any one of those holds a null value then the whole output is null. This is driving me nuts.

EDIT: I put in a query before this to replace all NULLS with ‘’ and i still get the same results. I tried replacing nulls with ’ '(space) too. what is weird is that if i do source->query->target then everything concats fine. it’s only when I add more queries that things start to go wrong.

DanHosler :us: (BOB member since 2013-06-19)

#2

Have you tried using the nvl() function around each field? This function will replace nulls with anything you want, in this case use ’ ’ as the replacement.

michael.ardizzone :us: (BOB member since 2008-03-11)

#3

Hey thanks for the reply. The solution was to replace nulls with something else. Apparently I missed one field last time I tried to do that. Thanks for the tip on that nvl function.

DanHosler :us: (BOB member since 2013-06-19)

#4

Would also like to much obliged for imparting this with us…It almost solve my half problem… :smiley: :smiley: :smiley:

manage Google apps

DonaldWoodsmith (BOB member since 2013-08-19)