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

ReliabilityWolf — Fri, 07 Jun 2024 01:52:00 GMT

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?

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

WebDesignesCrow — Fri, 07 Jun 2024 03:42:10 GMT

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" )
);

topic Re: Transpose column to rows and add Single quotation mark for each row in Discussions

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

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