nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

580184_en-US

liliconcom

get rows where: speed issue

Get rows where is extremely slow if the column is referenced with a varible (here i=5

i = 5;
dt << get rows where( As Column( dt, i ) == 999 );

instead of a direct reference like in

dt << get rows where( As Column( dt, 5 ) == 999 );

My wishes:

could you please explain why this is the case
could you please try to fix this issue in a future release of Jmp.
if fixing the issue is not possible, could you please implement a warning function in JSL such that the user gets informed about the bad performance.
Then he can adjust the code, e.g. with a substitute:
https://community.jmp.com/t5/Discussions/Should-you-Loop-through-a-data-table-or-use-Recode-or-use-Get/m-p/579844/highlight/true#M78711

Automation and Scripting

Basic Data Analysis and Modeling

Data Blending and Cleanup

Data Exploration and Visualization

Scripting

Sharing and Communicating Results

Statistics and Analytics

Comments

There are no comments yet