copy column cell to different column

[#1]

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;

[#2 · Accepted solution]

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

[#3]

working great thank you