topic Re: Duplicate a column in Discussions

Duplicate a column

moti617 — Fri, 31 Aug 2018 16:17:50 GMT

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

Re: Duplicate a column

uday_guntupalli — Fri, 31 Aug 2018 17:06:55 GMT

@moti617,

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

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

dt:weight-dup << delete formula ; // optional

Re: Duplicate a column

moti617 — Fri, 31 Aug 2018 17:33:24 GMT

Thank you,

Happen to know the sript for annonyizing a column?

Re: Duplicate a column

uday_guntupalli — Fri, 31 Aug 2018 18:27:26 GMT

@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

Re: Duplicate a column

moti617 — Fri, 31 Aug 2018 19:02:24 GMT

Thank you!

Appreciate the help.