880265_en-US

liliconcom

Multiple input for SQL data pull using JMP script.

I have a JSL script that pulls data from SQL. Currently, I have a list of order numbers in a table, and I am using that to pull data for all unique shop orders.

I would like to add a popup function to enter multiple shop orders. I was able to do that for one order. How can add multiple shop order in a pop up box?

 

Below is the script I came up with.

Names Default To Here(1);
Clear Globals();
//dt = current data table();
//Summarize(dt, uniq = By(:Column 1));
//sql_in = ConcatItems(uniq,",");

//****************************** Enter Leakage current below****************
Shop Order = New Window( "Enter Shop order",
	<<MODAL></MODAL>

list.

Basic Data Analysis and ModelingRe: Multiple input for SQL data pull using JMP script.

You could use text edit box and then parse the user input (use either << set function or parse it after you have the result)

Names Default To Here(1);

nw = New Window("Enter Shop order",
	<<MODAL></MODAL>

Or you could add + Button to add more number edit boxes

Names Default To Here(1);

nw = New Window("Enter Shop order",
	<<MODAL></MODAL>

or utilize number col edit box

Names Default To Here(1);

nw = New Window("Enter Shop order",
	<<MODAL></MODAL>

Re: Multiple input for SQL data pull using JMP script.

Thanks Jarmo,

Text edit box function worked great. 

 

When I enter multiple order number in a same raw and replace space with "," it worked fine. 

 

I want to make it robust. How can I handle the input when it is entered vertically.(I need this when I copy list from excel.)

 

Names Default To Here(1);

nw = New Window("Enter Shop order",
	<<MODAL></MODAL>

Re: Multiple input for SQL data pull using JMP script.

Best method I have come up with has generally been Regex but the pattern depends on your use case. In this case you could maybe just use Collapse Whitespace + Words

Names Default To Here(1);

nw = New Window("Enter Shop order",
	<<MODAL></MODAL>

 

You could also clean the input in such a way that user will see it when they commit the change

Names Default To Here(1);

nw = New Window("Enter Shop order",
	<<MODAL></MODAL>