cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • JMP will suspend normal business operations for our Winter Holiday beginning on Wednesday, Dec. 24, 2025, at 5:00 p.m. ET (2:00 p.m. ET for JMP Accounts Receivable).
    Regular business hours will resume at 9:00 a.m. EST on Friday, Jan. 2, 2026.
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.

Discussions

Solve problems, and share tips and tricks with other JMP users.
%3CLINGO-SUB%20id%3D%22lingo-sub-691447%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3EComment%20r%C3%A9cup%C3%A9rer%20une%20ligne%20de%20donn%C3%A9es%20d'un%20tableau%20dans%20une%20fen%C3%AAtre%20d'affichage%20s%C3%A9lectionn%C3%A9e%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-691447%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EJ'ai%20une%20fen%C3%AAtre%20contenant%20un%20tableau%20(c'est-%C3%A0-dire%20les%205%20premi%C3%A8res%20lignes%20de%20Big%20Class.jmp)%20que%20j'ai%20cr%C3%A9%C3%A9%20%C3%A0%20l'aide%20du%20script%20ci-dessous%20et%20j'aimerais%20savoir%26nbsp%3B%3A%3C%2FP%3E%3CP%3E1)%20qu'une%20ligne%20du%20tableau%20a%20%C3%A9t%C3%A9%20s%C3%A9lectionn%C3%A9e%3C%2FP%3E%3CP%3E2)%20r%C3%A9cup%C3%A9rer%20les%20donn%C3%A9es%20du%20tableau%20dans%20la%20fen%C3%AAtre%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUne%20fois%20la%20fen%C3%AAtre%20cr%C3%A9%C3%A9e%2C%20supposons%20que%20l'utilisateur%20s%C3%A9lectionne%20une%20ligne%20du%20tableau%20comme%20indiqu%C3%A9%20dans%20l'image%20ci-jointe.%3C%2FP%3E%3CP%3ERemarque%26nbsp%3B%3A%20j'utilise%20JMP%20version%2017.1.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3Enames%20default%20to%20here(1)%3B%0A%0Adt%20%3D%20open(%22%24sample_data%5Cbig%20class.jmp%22%2C%20invisible)%3B%0Arpt%20%3D%20dt%20%26lt%3B%26lt%3B%20select%20where(row()%26lt%3B5)%20%26lt%3B%26lt%3B%20get%20as%20report%3B%0Anw%20%3D%20new%20window(%22test%22%2C%0A%20v%20list%20box(%0A%20%20outline%20box(%22Big%20Class%22%2C%20rpt)%0A%20)%0A)%3B%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22big%20class%20example.jpg%22%20style%3D%22width%3A%20270px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22big%20class%20example.jpg%22%20style%3D%22width%3A%20270px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22big%20class%20example.jpg%22%20style%3D%22width%3A%20270px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22big%20class%20example.jpg%22%20style%3D%22width%3A%20270px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22big%20class%20example.jpg%22%20style%3D%22width%3A%20270px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22big%20class%20example.jpg%22%20style%3D%22width%3A%20270px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22big%20class%20example.jpg%22%20style%3D%22width%3A%20270px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22big%20class%20example.jpg%22%20style%3D%22width%3A%20270px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22big%20class%20example.jpg%22%20style%3D%22width%3A%20270px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22big%20class%20example.jpg%22%20style%3D%22width%3A%20270px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F58056iBEC2B393E64BFD19%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22big%20class%20example.jpg%22%20alt%3D%22big%20class%20example.jpg%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-691447%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CLINGO-LABEL%3EAutomatisation%20et%20scripts%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-691466%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%20%3A%20Comment%20r%C3%A9cup%C3%A9rer%20une%20ligne%20de%20donn%C3%A9es%20d'un%20tableau%20dans%20une%20fen%C3%AAtre%20d'affichage%20qui%20a%20%C3%A9t%C3%A9%20s%C3%A9lectionn%C3%A9e%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-691466%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3ELe%20rapport%20de%20la%20table%20de%20donn%C3%A9es%20est%20une%20zone%20de%20bordure%20avec%20une%20zone%20de%20tableau%20%C3%A0%20l'int%C3%A9rieur%20afin%20que%20vous%20puissiez%20l'utiliser%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22jthi_0-1698432515546.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1698432515546.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1698432515546.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F58057iAE0ABC64D2675366%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22jthi_0-1698432515546.png%22%20alt%3D%22jthi_0-1698432515546.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3ENames%20Default%20To%20Here(1)%3B%0A%0Adt%20%3D%20Open(%22%24sample_data%5Cbig%20class.jmp%22%2C%20invisible)%3B%0Arpt%20%3D%20dt%20%26lt%3B%26lt%3B%20select%20where(Row()%20%26lt%3B%205)%20%26lt%3B%26lt%3B%20get%20as%20report%3B%0Anw%20%3D%20New%20Window(%22test%22%2C%20%0A%20V%20List%20Box(%0A%20%20Outline%20Box(%22Big%20Class%22%2C%20%0A%20%20%20rpt%0A%20%20)%0A%20)%0A)%3B%0A%0Arpt%5BTable%20Box(1)%5D%20%26lt%3B%26lt%3B%20Get%20Selected%20Rows%3B%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3Eune%20fois%20que%20vous%20connaissez%20le%20type%20d'objet%2C%20vous%20pouvez%20voir%20assez%20facilement%20%C3%A0%20partir%20de%20l'index%20de%20script%20ce%20que%20vous%20pouvez%20faire%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22jthi_1-1698432573633.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_1-1698432573633.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_1-1698432573633.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F58058iA3A8E8F26EEC6C80%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22jthi_1-1698432573633.png%22%20alt%3D%22jthi_1-1698432573633.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3Eou%20vous%20pouvez%20utiliser%20Afficher%20les%20propri%C3%A9t%C3%A9s%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3EShow%20Properties(rpt%5BTable%20Box(1)%5D)%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar
tbidwell
Level III

How do I retrieve a row of data from a table in a display window that has been selected?

I have a window that has a table in it (i.e., the first 5 rows of Big Class.jmp) that I created using the script below and I'd like to know:

1) that a row of the table was selected

2) retrieve the row of data from the table in the window

 

After the window has been made, let's assume the user selects a row of the table as shown in the attached image. 

Note: I am using JMP ver 17.1.

 

names default to here(1);

dt = open("$sample_data\big class.jmp", invisible);
rpt = dt << select where(row()<5) << get as report;
nw = new window("test",
	v list box(
		outline box("Big Class", rpt)
	)
);

big class example.jpg

1 ACCEPTED SOLUTION

Accepted Solutions
jthi
Super User

Re: How do I retrieve a row of data from a table in a display window that has been selected?

Report from data table is Border box with Table box inside it so you can use that

jthi_0-1698432515546.png

 

Names Default To Here(1);

dt = Open("$sample_data\big class.jmp", invisible);
rpt = dt << select where(Row() < 5) << get as report;
nw = New Window("test", 
	V List Box(
		Outline Box("Big Class", 
			rpt
		)
	)
);

rpt[Table Box(1)] << Get Selected Rows;

after you know the object type you can fairly easily see from scripting index what you can do

jthi_1-1698432573633.png

or you could use Show Properties

Show Properties(rpt[Table Box(1)])
-Jarmo

View solution in original post

1 REPLY 1
jthi
Super User

Re: How do I retrieve a row of data from a table in a display window that has been selected?

Report from data table is Border box with Table box inside it so you can use that

jthi_0-1698432515546.png

 

Names Default To Here(1);

dt = Open("$sample_data\big class.jmp", invisible);
rpt = dt << select where(Row() < 5) << get as report;
nw = New Window("test", 
	V List Box(
		Outline Box("Big Class", 
			rpt
		)
	)
);

rpt[Table Box(1)] << Get Selected Rows;

after you know the object type you can fairly easily see from scripting index what you can do

jthi_1-1698432573633.png

or you could use Show Properties

Show Properties(rpt[Table Box(1)])
-Jarmo

Recommended Articles