Choose Language Hide Translation Bar
Highlighted
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
Highlighted
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
Highlighted
moti617
Level II

Re: Duplicate a column

Thank you,

Happen to know the sript for annonyizing a column?

Highlighted
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
Highlighted
moti617
Level II

Re: Duplicate a column

Thank you!

Appreciate the help.

Article Labels

    There are no labels assigned to this post.