Interested to Buy Any Domain ? << Click Here >> for more details...
Total Questions Posted # 0
Total Answers Posted # 1
Total Answers Posted for My Questions # 0
Total Views for My Questions # 0
Users Marked my Answers as Correct # 4
Users Marked my Answers as Wrong # 0
Total Answers Posted # 1
Total Answers Posted for My Questions # 0
Total Views for My Questions # 0
Users Marked my Answers as Correct # 4
Users Marked my Answers as Wrong # 0
Questions / { vidhya }
Questions
Answers
Category
Views
Company
eMail
Answers / { vidhya }
i have source as
Column1
101 a 101 b 101 c
so i want to load target as
column1 ---> 101 abc
Answer
In exp transformation
newport1 - SUBSTR(column1,1,3)
newport2 - LTRIM(RTRIM(column1))
newport3 - REPLACECHR(1,newport2,'101','')
newport4 - newport1 || ' ' || newport3
pass newport4 to target
anyone pls confirm if it is wrong
| Is This Answer Correct ? | 4 Yes | 0 No |
