topic Re: copy column cell to different column in Discussions

copy column cell to different column

AdamChoen — Mon, 26 Feb 2018 11:13:04 GMT

I'm trying to copy all row that is gender "male" from column "age" to column "gender"

this syntax doesn't work.

appreciate any help!

age is a character column (Young, adult etc.)

dt <<Select Where(:gender== "M");
:age << Get Value;
:gender << paste;

Re: copy column cell to different column

txnelson — Mon, 26 Feb 2018 11:45:53 GMT

Here is the code that I would use....others may have better

Names Default To Here( 1 );
dt = Current Data Table();

selRows = dt << Get Rows Where( :gender == "M" );
For( i = 1, i <= N Rows( selRows ), i++,
	:gender[selRows[i]] = Char( :age[selRows[i]] )
);

Re: copy column cell to different column

AdamChoen — Mon, 26 Feb 2018 12:41:59 GMT

working great thank you