DSXchange

Hi all,

Could you please let me know how to concatenate
two values with blank space.
my reqirement is some thing like
concatenate lastname and fristname
with blank value
foe example
fristname-->GIRI
lastname--->KIRAN
reqired reult is GIRI KIRAN
So far i tried with
fristname : ' ' : lastname

but its giving result 0

Any suggestions???

fristname-->GIRI
lastname--->KIRAN
fristname:' ':lastname

dont give any spaces in between and then try, it is working for me.

fristname-->GIRI
lastname--->KIRAN
fristname:' ':lastname

dont give any spaces in between and then try, it is working for me.

Hi,
Are fisrt name and secomd names two different columns.

Use below logic

fristname : Space(1) : lastname .

Let me know how it works.

Thanks
Sana

What is the datatype for target column ?

nani0907 wrote:Hi,
Are fisrt name and secomd names two different columns.

Use below logic

fristname : Space(1) : lastname .

Let me know how it works.

Thanks
Sana

Hi ,

thanks for respond,

now its giving
fristnameSpace(1)astname.
not giving appropriate result

Hi Murthy,

1. What is the stage you are using?

2. As Sainath asked what is the datatype of the target column

This is pretty straight forward. You just have to use a transformer and use the following derivation

LinkName.FirstName:" ":Linkname.LastName

HTH
--Rich

Sainath.Srinivasan wrote:What is the datatype for target column ?

Data type is varchar2

hi,


now its working fine.

Thanks

If one of the variables are null, the whole string will evaluate to null: i.e.

Firstname: ' ' : Lastname

If Firstname = 'Rob'
Lastname - 'Wierdsma'
result will be 'Rob Wierdsma'

If Firstname = null
Lastname = 'smith'
result will be null.