Hi all ,
I want in a transformer to do :
column1:' ':column2 ---> target
55 :' ': KK ---->55 KK
And when column1 is empty I'm expecting to have
column2 -->target
but I have nothing in target
Do you have an idea ?
concatenating string
Moderators: chulett, rschirm, roy
Are you doing a simple derivation in a transform stage? If your first column is empty, what output are you getting that is wrong?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Re: concatenating string
If one of the two columns is NULL, the result will be NULL and not what you're expecting.
You'll have to catch the NULL and convert it to an empty string
You'll have to catch the NULL and convert it to an empty string