What inspired this wish list request?
When joining data tables with Tables > Join, I often want to include all the columns from one table, while selecting only certain column from the other. In case where the "keep all" table may have varying columns (different columns, column names), and where I want a reproducable script to do the join, it can be difficult and complex
What is the improvement you would like to see?
Add an "all" wildcard option to Tables > Join.
Here is the Scripting Index exam;le for Join
Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Trial1.jmp" );
dt2 = Open( "$SAMPLE_DATA/Little.jmp" );
dt << Join(
With( Data Table( "Little" ) ),
Select( :popcorn, :oil amt, :batch, :yield ),
SelectWith( :yield ),
By Matching Columns( :popcorn = :popcorn, :batch = :batch, :oil amt = :oil )
);
I would like to do something list this
Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Trial1.jmp" );
dt2 = Open( "$SAMPLE_DATA/Little.jmp" );
dt << Join(
With( Data Table( "Little" ) ),
Select( all ),
SelectWith( :yield ),
By Matching Columns( :popcorn = :popcorn, :batch = :batch, :oil amt = :oil )
);
Why is this idea important?
This would be for JSL coding efficiency and have the ability to joins on more general tables easily,
... View more