copy column cell to different column

AdamChoen

hi 

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;

txnelson

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