Hi Everyone.
How to concatinate different columns in transformer stage? I have 10 columns in the input of which 9 are char datatype and one is decimal. My reuqirement is to concatinate all the 10 fileds to one field use the field as key to merge. what i have done is created a new filed ABC of datatype varchar 255 and concatinated all the source 10 fields and loaded into dataset. But when i view the data i see only first 2 fields were concatinated. Please let me know where iam doing wrong. Share your ideas.
Thanks in Advance
Concatination not working
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 334
- Joined: Fri Dec 01, 2006 5:17 am
- Location: Texas
Hi,
For the decimal data type you have to use "DecimalToString" function and target datatype will be LongVarchar.
Following is code which I have used:
Hope this will help you
Thanks!
For the decimal data type you have to use "DecimalToString" function and target datatype will be LongVarchar.
Following is code which I have used:
Code: Select all
DSLink2.COL1:DSLink2.COL2:DSLink2.COL3:DSLink2.COL4: DecimalToString(DSLink2.COL5)
Thanks!
http://findingjobsindatastage.blogspot.com/
Theory is when you know all and nothing works. Practice is when all works and nobody knows why. In this case we have put together theory and practice: nothing works. and nobody knows why! (Albert Einstein)
Theory is when you know all and nothing works. Practice is when all works and nobody knows why. In this case we have put together theory and practice: nothing works. and nobody knows why! (Albert Einstein)
Hi,
I tried with by using the decimal to string fucntion but still not getting the desired output. Iam extracting the data from Mainframe DB2 tables. Is it something to do with the lowvalues? or inline nulls? if there are any chances of having low values could any one let me know how to convert and proceed with the logic.
Thanks
I tried with by using the decimal to string fucntion but still not getting the desired output. Iam extracting the data from Mainframe DB2 tables. Is it something to do with the lowvalues? or inline nulls? if there are any chances of having low values could any one let me know how to convert and proceed with the logic.
Thanks
Since we don't know what your output was, or what your desired output was there is little that anyone here at DSXChange can do to help until you explain the issue.pradkumar wrote:...I tried with by using the decimal to string fucntion but still not getting the desired output...
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: