☐ cool new feature
☑ could help many users!
☑removes something that feels like a „bug“
☐ nice to have
☐ nobody needs it
What inspired this wish list request?
In general, Jmp doesn't distinguish between upper and lower case - and Jmp ignores white spaces in Symbol names.
So, :age can refer to the same column as :A G E
But :age and :A G E can be also different columns.
check if column exists?
JSL ignores white-spacing for names, most people don't take advantage of this!
Let's take the Concatenate platform as an example. This platform is very picky with column names.
If Table A has a column :age and table B has a column :A G E,the combined table will contain 2 columns!
In general this is a nice feature: better split the columns, the user can merge them later.
But for user who lived the carefree life of "difference don't matter" - the first collision with Concatenate can be traumatic.
What is the improvement you would like to see?
In Concatenate (and other platforms?) please provide an option "Column Names: Exact match".
If the option is on, Concatenate is as picky as now, if it's off, Concatenate follows the usual rules of JMP/JSL when comparing column names.
Why is this idea important?
- The option will give the user more possibilities.
- The presence of the option will generate awareness!
- The idea is related to the option Exact Match (1 |0) of dt << has column(), which will be introduced with Jmp18:
data table : message column exists(colname)?
more wishes by