Interested to Buy Any Domain ? << Click Here >> for more details...
if a column contains data like
ram,rakesh,madhan,suraj,pradeep,bhaskar then I want to
place names separated by commas in another columns how can
we do?
- 5 Answers
- 10506 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
seq file ------> Transformer -------> target
1.extract the source data into seq file.
2.In transformer source column to target , and apply the field function
Field(column name, ',' , 1)
next same drag the source column to target , and apply the field function
Field(column name,',',2)
.
.
.
Field(column name,',',5)
| Is This Answer Correct ? | 8 Yes | 0 No |
Well the Question is not clear at the moment.
if ur question is
1)single col with single row like
name
ram,rakesh,madhan,suraj,pradeep,bhaskar
then
ur requirement of asking is again this?
like
ram,rakesh,madhan,suraj,pradeep,bhaskar
or
2)single col with multiple rows like
ram
rakesh
madhan
suraj
pradeep
bhaskar
and u want o/p like ram,rakesh,madhan,suraj,pradeep,bhaskar.
Then praney anwer doesn't suite to get output.
neither u can use pivot stage using vertical pivoting bec
what will u pivot and group by.... not possible.
Finally one way is:
Use SeqStg-->ColGen-->Tx-->RemDup-->Dataset.
At colgen give a new column and assign 1 to all rows and
send the result to tx.
At tx take three variables and expressions to concatenate
the input with the help of colgen new column.
Hint: If sv1 <> sv3 Then DSLink45.cname Else sv2 : ',' :
At RemDup specify Last value
And finally u will the output.
Still if u dont get what i explained just mail me
shharrath@yahoo.com
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / santhu
Then We have to concatenate by using concatenation operation with comma(,)in transformer
| Is This Answer Correct ? | 1 Yes | 2 No |
Answer / abhishek
No Need of fileds and all extraact al the columns in
transfarmerstage create a new column in transe as exprestion
col1,col2,col3 and load it
| Is This Answer Correct ? | 0 Yes | 3 No |
how to abort the job its matain duplicates?
What are the types of hashed files in data stage
What is the difference between account and directory options ?
what is 'reconsideration error' and how can i respond to this error and how to debug this
How many input links can you give to a Transformer stage?
Hi friends, I am new to datastage, i have one query in datastage any one you please give reply to my post. I have a workbook (excel sheet) named as eg: xxxx, in that i have two tables emp(eid, ename, salary, deptno) and dep(deptno, name, state). in my source i have ODBC enterprise stage read the emp table and dept table join the two table and write the dept no 10(eid,ename,salary,name,state) values in target(). Thanks, Badari
on how many columns we can perform aggregation in the aggregator stage?
What is the difference between the local container and shared container?
i have a scenario in which i/p columns areID,salary with 1,1000 2,2000 and 3,3000 i need an extra column in the o/p named avg(salary)how can i get it?
1.What is the flow of Transformer? 2.How can you do INDEX table in DataStage level?
Difference between server jobs & parallel jobs?
What is the importance of the exception activity in datastage?
Teradata 
