Work flow builder

[#1]

Hi All, 

I recorded a seqeunce of data clean up steps on a file using workflow builder. I would like to be able to just change the name of the file and carry out the same set of steps however, some of my setps have name of the data table I orignially used to built the work flow builder. 

Is there a way I can update the names of the table to the latest table? 




e.g 
I have one of the steps as follow
Data Table("12_09") <<Select Where(!(Contains(PBI,:c000002))) << delete rows:
now when I open the data table my workflow wont excute because, the name of the table now is 13_09 

I was trying maybe to create a variable that always gets the name of the table that opened and use it through out the steps carried on workflow builder. 

Thanks in advance. 

[#2]

A kind of workaround:
close the original table. Then workflow Builder cannot find it and will ask which table to use:

The advantage - and disadvantage: 
When you save the Workflow now, Jmp will save this replacement info - and next time it will search for the new name and not for the old name anymore.

The replacement rules can be activated, checked and reset via the red triangle:

maybe: use a very strange table name when recording the workflow ... then rely on the replacement function

- and reset the replacement rule before you save the workflow [such that Jmp will search again for the table with the strange name].

[#3]

Hi. I would suggest using the Workflow Builder option, References > Manage... This will allow you to specify when to prompt for data table or column references. 

[#4]

Right, much better than my workaround with the strange table name

[#5]

There is another way of doing this in the workflow script.

At the step where you open the data table, rather than have the script as Open ("12_09") - edit it to:

browse = pick file();

open(browse)

When you run the workflow it will prompt you to select the appropriate file when the workflow gets to that step.

If you are using the table at multiple steps you can have the script as:

browse = pick file();

open(browse) << save ("XXX") 

and then just change all subsequent sections of the script that ask for "12_09" to "XXX"

[#6]

Thanks.  feels much smoother than:

- Pick file: which input table file ?

- next workflow step: which data table ?

I tried it before with << set name() instead of << save.

But Jmp added " 2" to prevent a table name collision.

The benefit of save: it forces the file to be saved with the given  name

- nice workaround

[#7]

With Jmp18, there is a new approach which doesn't require any scripting *)
https://community.jmp.com/t5/Benelux-JMP-Users-Group/Workflow-Builder-or-the-quot-baby-steps-quot-in... 

1) use a workflow step #1 to open/create new table(s):
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:

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  

*) at the moment, the approach doesn't works for ".jmp" files.
TS-00135464