concatenate two columns

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
vemisr
Participant
Posts: 72
Joined: Thu Sep 11, 2008 1:31 pm

concatenate two columns

Post by vemisr »

HI ,

how can i concatenate two columns in transformer.

link2.first_name : link2.Last_name

so i need to get the firstname lastname.


thanks
Vemi
Top
anil411
Premium Member
Premium Member
Posts: 53
Joined: Thu Aug 11, 2005 8:34 am

Re: concatenate two columns

Post by anil411 »

Try this:
link2.first_name :" ": link2.Last_name
Top
ajay.vaidyanathan
Participant
Posts: 53
Joined: Fri Apr 18, 2008 8:13 am
Location: United States

concatenate two columns

Post by ajay.vaidyanathan »

Hi,
You can use this Col1:Col2
Regards
Ajay
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”