Single column with multiple rows should be converted into single row with commas in datastage

Can any one help....
I have single column in Source like.....
a
b
c
d
want target as.....
a,b,c,d
thanks in advance

Questions by sai3689   answers by sai3689

Showing Answers 1 - 6 of 6 Answers

jallu

  • Apr 11th, 2015
 

by using pivot stage in datastage

  Was this answer useful?  Yes

D Hema

  • Apr 23rd, 2015
 

use the stag variable in the transformer
StageVar=StageVar:,: input column name
go to the constraints :-Lastrow()
map that stage variable to the output column

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions