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

Can any one help....
Source is.....
a
b
c
d
want target as.....
a,b,c,d
thanks in advance

Questions by sai3689   answers by sai3689

Showing Answers 1 - 5 of 5 Answers

vasuu

  • Apr 13th, 2015
 

uses pivot stage or u can tx by stage variables

  Was this answer useful?  Yes

amulya kumar panda

  • Apr 17th, 2015
 

add one extra column that value 1 or any thing but value same
Use a vertical Pivot option available in Pivot Enterprise stage(Stage tab-->Properties-->Pivot Type=Vertical)
Again in stage-->Pivot properties tab-->group by on extra column and Pivot using source column.
Then select array size= as your value.

preeti

  • Aug 9th, 2017
 

You can create a other array with some size and insert data in single array from double array for more see the following code



for(int i=0;i {
System.out.print(a1[i]);
}
}

}

Code
  1.  

  Was this answer useful?  Yes

kalyanreddy

  • Jan 30th, 2024
 

using with pivot stage, we can convert the rows into columns ; source --> pivot -->target.

  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