Concatenation function to be used in transformer?

raam_datastage · Post by **raam_datastage** » Mon May 05, 2008 11:27 pm

I need to concatenate two string fields.what is the equivalent of : in parallel edition?.Is concatenation possible in modify stage?

devidotcom · Post by **devidotcom** » Mon May 05, 2008 11:31 pm

As far as I know concatentation is not possible in modify stage

raam_datastage · Post by **raam_datastage** » Mon May 05, 2008 11:32 pm

Column export stage is one way to do this.But are there any concatenation function available which can be used in transformer?

raam_datastage · Post by **raam_datastage** » Mon May 05, 2008 11:34 pm

Column export stage is one way to do this.But are there any concatenation function available which can be used in transformer?

devidotcom · Post by **devidotcom** » Mon May 05, 2008 11:36 pm

Yes in transformer we can do it but without any function just use :

String1:String2

BugFree · Post by **BugFree** » Mon May 05, 2008 11:38 pm

Concatenate is same ":" in parallel as well. You can do it in a transformer stage. Not sure about Modify though.

krisna · Post by **krisna** » Tue May 06, 2008 1:23 am

In transformer we can use ":" for concatenating two strings.

The modify stage alters the record schema of its input data set. The modified data set is then output.

I think modify stage cannot be used for concatenating.

krisna · Post by **krisna** » Tue May 06, 2008 1:24 am

In transformer we can use ":" for concatenating two strings.

The modify stage alters the record schema of its input data set. The modified data set is then output.

I think modify stage cannot be used for concatenating.