777225_en-US

liliconcom

Simple way to copy and paste columns

What inspired this wish list request? 

There are many instances when I need to combine columns from different data tables into a new table. I know there are workarounds to do this (subsets, get script, etc), but why can't there be a simple copy column/paste column command?

 

What is the improvement you would like to see? 

Add copy/paste column commands to JSL

 

Why is this idea important? 

Makes a common task very simple instead of resorting to more complex JSL workarounds.

 

Automation and ScriptingRe: Simple way to copy and paste columns

you mean:
 << copy column as a synonym for << get script?

If  copy column(col)is fine for you [instead of dt << copy column(col)],
  you can create a wrapper for << get script:

Names Default to Here(1);
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
dt2 = Open( "$SAMPLE_DATA/Big Class Families.jmp" );

dt << New Formula Column(
	Operation( Category( "Combine" ), "Ratio" ),
	Columns( :height, :weight )
);

copy column = Function({col},
	script = col << get script
);

paste column = Function({},
	script
);

copy column (Name Expr(Column("height/weight")));
Current data table(dt2);
paste column();

And via the GUI,  copy column / paste column is also available:

Re: Simple way to copy and paste columns

I'm looking for something that is as simple as the copy/paste column items in the GUI but for JSL.

 

Just dt << copy column (:name)

and

dt2 << paste column

no expr or any other JSL involved.

 

Maybe with a couple of position modifiers such as , , etc.

Re: Simple way to copy and paste columns

Interestingly... there is a Copy Column command listed in the scripting index. But it has no information about it. I can't find it in the scripting guide.

 

But there is no Paste Column.

Re: Simple way to copy and paste columns

Another interesting variation of this might be to add modifiers to the New Table command to list columns to pull from other tables

 

New Table (dt1:colname, dt1:colname2, dt2:colname3)

 

This would create a New Table with the columns pulled from dt1 and dt2

Re: Simple way to copy and paste columns - Status changed to: AcknowledgedRe: Simple way to copy and paste columns

Your function 

New Table (dt1:colname, dt1:colname2, dt2:colname3)

 

looks like the existing:

dt1 << Subset(All rows,	Selected columns only( 0 ),	columns( :colname, :colname2, :colname3));

Re: Simple way to copy and paste columns

To refund money from Phone Pe for a wrong transaction, you should immediately contact PhonePe's customer support:0,(7806√943-293) and (available 24/7) report