topic Re: Simple start for script in Discussions

Simple start for script

gueriniere — Sat, 10 Jun 2023 23:44:49 GMT

I am a bit embarrased that I get stuck on this simple task.

It is a simple task:

I have 2 data-tables (dt-1 and dt-2). I want to step through the first and for each row compare a value with a value in the second table, starting with first row in that table. If it is close enough I will collect a value from that dt-2 and save in a field in dt-1, put a special marker in a field in dt-2 so I know that row is taken and step to next row i dt-1, if it is not close enough I will step to next row in dt-2.

The programming is simple enough:

for(i=1 to i > row_count(dt-1), dt-1 (row-number = i), 
  for (j=1 to j>row_count(dt-2), dt-2 (row-number = j,
    if(dt-2(col-x) == dt1(col-y), dt_2(col-z=1; dt1(col-z)=dt2(col-a); i++; j=0, j++)
)

My questions:

What is the command in jsl to get the row-count of a dt?

What is the command in jsl to go to a specific row in a dt?

What is the command in jsl to retrieve the value from a specific column in a specific row?

What is the command in jsl to write data to a specific field in a specific row of a specific dt?

When I try to go through the instructions and manuals I get stuck in al discussions on how to create loops and simple ordinary programming but I cant find these references to dt, fields and rows. I'm probably blind but please help me where to look!

Re: Simple start for script

pmroz — Thu, 24 Feb 2022 14:05:35 GMT

What is the command in jsl to get the row-count of a dt?

num_rows = nrows(dt);

What is the command in jsl to go to a specific row in a dt?

You don't go to a specific row - just reference the row number with brackets. See your next question.

What is the command in jsl to retrieve the value from a specific column in a specific row? Assuming your specific column is called specific_column:

one_value = dt:specific_column[i];

What is the command in jsl to write data to a specific field in a specific row of a specific dt?

dt:specific_column[i] = new_value;

Re: Simple start for script

jthi — Thu, 24 Feb 2022 15:00:57 GMT

There is at least one other option for accessing row BUT I WOULD ALWAYS prefer the method @pmroz showed. I have used this mostly for debugging and not updating values in the datatable

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

Row() = 10;
:height = 11;

Check out also this post Data table subscripting

Re: Simple start for script

gueriniere — Thu, 24 Feb 2022 19:11:30 GMT

Tnx!! I knew it was simple but one can die searching for simple things!