cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Submit your abstract to the call for content for Discovery Summit Americas by April 23. Selected abstracts will be presented at Discovery Summit, Oct. 21- 24.
Discovery is online this week, April 16 and 18. Join us for these exciting interactive sessions.
Choose Language Hide Translation Bar
moti617
Level II

Duplicate a column

Hello,

 

I'm relatively new to scirpting..

I'm interested in simply duplicate a column within the existing table. I would the duplicated column to be last and have a different name. 

After that, I would like to annonymize the original column.

 

Thanks 

4 REPLIES 4
uday_guntupalli
Level VIII

Re: Duplicate a column

@moti617

        

dt = Open( "$SAMPLE_DATA/Big Class.jmp" );; 

dt << New Column("weight-dup",numeric,continuous,formula(:weight)); 

dt:weight-dup << delete formula ; // optional 
Best
Uday
moti617
Level II

Re: Duplicate a column

Thank you,

Happen to know the sript for annonyizing a column?

uday_guntupalli
Level VIII

Re: Duplicate a column

@moti617,
       Try the following. 

dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
dt << anonymize( columns( :name, :age ), output table name( "anonymized" ) );

      Also, the following are really useful resources that you have at your disposal, that you should try and start exploring: 

 

1. Scripting Index 
2. Sample Data 
3. Books 
image.png

Best
Uday
moti617
Level II

Re: Duplicate a column

Thank you!

Appreciate the help.