Transformer concatenate

[suryadev]

While using concatenate in transformer,

first create a field...by any NAME in the columns in the bottom of properties of transformer

and then...in the output field use..the empty space on the left of the new field.
in that..empty space called derivation.right click and select a column and concatenate and then again column again concatenate...

it goes like-->dslink.first_nm:dslink.middle_nm:dslink.last_nm:concatenate
is this the right way to use concatenate...and length....also.add all the three fields lengths and that will be the length of the new field....NAME

Please let me know if I need to change anything...because...

the ouput which I am getting right now...is not in an order....and I am missing some text in that...output...

[anbu]

You should get the order you have it in your derivation.

Add derivation separately for all the columns included in your concatenation and verify you have values in all the fields

[arun_im4u]

If any of your three fields are NULL then your output is going to be NULL, bcause concatenation with NULL will result in a NULL.

You will get the same length in the output only if your are concatenating CHAR fields. If you are concatenating varchar type fields then the length might differ.

If the above are true you should be getting the right results.

There is a concatenate at the end of your derivation. Is that a typo?

dslink.first_nm:dslink.middle_nm:dslink.last_nm[b]:concatenate[/b]

[suryadev]

There are 4 fields and I want them to be as a single field so I used concatenate only to my new Field derivation because that is the only field available...now in the output
and I did not use any constraint in the transformer as I used concatenate in my New single field.