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
- 10724 Views
- I also Faced
- E-Mail Answers
Answer Posted / shar
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 |
Post New Answer View All Answers
How can we improve the performance in datastage?
Lookup constraints
what are the devoleper roles in real time? plz tell i am new to datastage....
What is the purpose of pivot stage and types of containers in datastage
Define data aggregation?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
Define oconv () and iconv () functions in datastage?
How to Remove Duplicate using SQL?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
sed,awk,head
Differentiate between Join, Merge and Lookup stage?
What are stage variables, derivations and constants?
What is the sortmerge collector?
How to manage date conversion in Datastage?
