Rules To Be Followed For Concatenation

praguur86 · Post by **praguur86** » Thu Jul 16, 2009 12:40 am

I am trying to concate more than two columns of data type char to one column, but i am able to concate only two columns but not all......
please suggest me how can i achieve this....
Is there any rules or modification need to be follow to do ......

jcthornton · Post by **jcthornton** » Thu Jul 16, 2009 12:43 am

How are you trying to concatenate the columns together? The exact code would be best if you can post it.

Are there any error messages? Warnings? If so, what are they?

I would also consider what the datatypes are that you are trying to concatenate. If there are any fields that are not a char/varchar type, use an explicit conversion routine. Also, are you using null handling routines for the nullable columns?

ArndW · Post by **ArndW** » Thu Jul 16, 2009 12:57 am

Also, which stage are you using to do this?

praguur86 · Post by **praguur86** » Thu Jul 16, 2009 1:01 am

Following is the code i am using...
If IsNull(DSLink3.FIRSTNAME) Then ',' Else Trim(DSLink3.FIRSTNAME) : ',' : If IsNull(DSLink3.LASTNAME) Then ',' Else Trim(DSLink3.LASTNAME)

And i am not getting any warrning or error.Job is completing successfully.
I am handling null also.

praguur86 · Post by **praguur86** » Thu Jul 16, 2009 1:03 am

I am using Transformer Stage....

ray.wurlod · Post by **ray.wurlod** » Thu Jul 16, 2009 1:10 am

praguur86 wrote:Following is the code i am using...
If IsNull(DSLink3.FIRSTNAME) Then ',' Else Trim(DSLink3.FIRSTNAME) : ',' : If IsNull(DSLink3.LASTNAME) Then ',' Else Trim(DSLink3.LASTNAME)

And i am not getting any warrning or error.Job is completing successfully.
I am handling null also.

Only two columns are mentioned here. This might be why you are not getting more column values in the result.

praguur86 · Post by **praguur86** » Thu Jul 16, 2009 4:29 am

any updates regarding concatination...
i tried to achive using table level concatenation, there als i am facing problem

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu Jul 16, 2009 5:15 am

Can you provide the full transformation rule with the input and output values to explain the issue you are facing.

Without that others can do very little only.

chulett · Post by **chulett** » Thu Jul 16, 2009 5:26 am

Just... keep going. You can string together as many if-then-else statements between colons as you'd like.