52053_en-US

liliconcom

copy column cell to different column

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=""></SELECT>

Re: copy column cell to different column

working great thank you 

Re: copy column cell to different column

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