topic Re: Use the content of a selected cell and use it as the name for a new column. in Discussions

Use the content of a selected cell and use it as the name for a new column.

Heinrich — Fri, 09 Jun 2023 16:59:00 GMT

Dear all, I try to create a script where I use the cell value or content of a selected cell an use this as the name for a new created column.

In general I could not find the script command to copy or read the content of a selected cell - maybe it is to obvious that I can't find it...

Many thanks for any help.

Re: Use the content of a selected cell and use it as the name for a new column.

Mark_Bailey — Wed, 11 May 2022 15:56:01 GMT

See the Scripting Index for specific syntax information. You can query the data table to get the currently selected rows. You can likewise query to get the currently selected columns. You access individual values in the data table using subscripts: dataTable[row,column].

Re: Use the content of a selected cell and use it as the name for a new column.

Byron_JMP — Thu, 12 May 2022 18:16:08 GMT

here's a little something to help you get started.

//Make an example table
dt=New Table( "Example",
	Add Rows( 5 ),
	New Column( "Column 1",
		Character,
		"Nominal",
		Set Values( {"alpha", "beta", "gamm", "delta", "ice-cream"} )
	)
);

//get the value of the first column in dt, at the 5th row
nnn=column(dt,1)[5];
//make a new useing the value obtained above
dt<<new column(nnn);