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,
Also, yes, I do know that Query Builder can use SQL wildcards, but I don't prefer using Query Builder. Join has a JSL simpler syntax and is in general more readable than Query Builder's JSL code.
Thank you for submitting this request and adding additional information in the comments!
