Transpose column to rows and add Single quotation mark for each row

Question

How can I use JSL to Transpose one column (:Number) to rows and add single quotation mark for each row?

or add add single quotation mark for each row of "Number" column, then Transpose to row?

WebDesignesCrow · Accepted Answer

Hi @ReliabilityWolf

Perhaps you can try this JSL script.

//To add prefix single quotation mark
Names Default to Here( 1 );
dt = current data table();
dt:Number << Data Type( Character);
for each row(
	dt:Number = "'" || dt:Number
);

//To transpose Number column to row
// Transpose data table
// → Data Table( "Transpose of dt" )
Data Table( "dt" ) << Transpose(
	columns( :Number ),
	Output Table( "Transpose of dt" )
);