cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Registration open for Discovery Summit Europe. User Group Members benefit from a 25% discount with the code: DSEUgroup24

Workflow Builder or the "baby steps" into Scripting

Workflow Builder is a new utility to record your JMP data preparation and analysis workflows. It is a way to capture, build, manage, and share your data steps and work without resorting to scripting. Learn how to easily reproduce and recycle an analysis that will save you and your organization precious time.

 

3 REPLIES 3
hogi
Level XI

Re: Workflow Builder or the "baby steps" into Scripting

Jmp 18: more options to structure a Workflow:

hogi_0-1711570348193.png

 



hogi
Level XI

Re: Workflow Builder or the "baby steps" into Scripting

Concerning the issue with the Table References, which was discussed in the Q&A 
... there seems to be a workaround available with Jmp18: FOR EACH:
example-of-a-workflow-with-a-for-each-loop.shtml 

 

1) use a workflow step #1 to open/create new tables:
Subset by, open() Multi File Import ...

 

2) Select step #1 as "Source" for a FOR EACH loop


3) and add as many workflow steps as you want to the For Each branch:

hogi_2-1711628381086.png

independent of the Data Table name in the individual steps, for all steps in the For Each loop, Jmp will use the the tables which were opened in step #1  

 

If you want to generate another data table (like a summary table) and use it as an input for another report, please take care that this report is placed OUTSIDE of the FOR EACH loop
[otherwise the table reference in the step will also be replaced with the one from step #1]

*) edit: in a previous version of the post, I wrote that Jmp analyzes the return value of the input step

hogi
Level XI

Re: Workflow Builder or the "baby steps" into Scripting

There are 2 modes:
With "Workflow Step", Jmp will automatically replace all table references within the For loop with the data table from the input step, NOTHING to define/change in the individual steps *)

 

Iteration Variable (item #1, item #2 ,...)  and Index Variable (1, 2 , ...) can be used - but are mainly needed for mode that uses the JSL Variable.

hogi_3-1711642231849.png

 

*) just try it with:

Print(// Iteration Index ,  Iteration Variable, 
Data Table("xyz") << get name();  );

Jmp detects the Data Table ("xyz") in the code and replaces it automatically with the data table from the input step.

hogi_5-1711642347260.png

Almost too extreme - like indicated in the previous post:

even a reference to a summary table will be replaced with a reference to the input table - if the specific step is inside the For Each loop.