BookmarkSubscribe
Choose Language Hide Translation Bar
moti617
Community Trekker

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 

0 Kudos
4 REPLIES 4
uday_guntupalli
Community Trekker

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
Community Trekker

Re: Duplicate a column

Thank you,

Happen to know the sript for annonyizing a column?

0 Kudos
uday_guntupalli
Community Trekker

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
Community Trekker

Re: Duplicate a column

Thank you!

Appreciate the help.

0 Kudos