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...
Transformer concatenate
Moderators: chulett, rschirm, roy
Transformer concatenate
Thanks,
Surya
Surya
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]
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]