cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar

Workflow and Alert to record delete columns which are referenced to another columns

What inspired this wish list request? 

Workflow did not show the correct scripts to delete columns which are referenced to another columns. The alert is confusing as well.

Currently, Workflow in JMP 17 only record "Delete Columns" but not full script to "Delete Columns" which referenced to another columns.

WebDesignesCrow_1-1688608660210.png

WebDesignesCrow_2-1688608687429.png

Workaround available through scripting (1st: Delete Formula in columns that contain formula (E.g Column B), 2nd: Delete Columns (E.g Column A) that being referenced for the formula in Column B).

But the objective of workflow is to have automated steps that can be shared, so that other colleagues in the organization can run the same analysis & result. 

 

https://community.jmp.com/t5/Discussions/How-to-delete-reference-of-formula-column-in-JSL/m-p/654997...

 

What is the improvement you would like to see? 

1) Alert  "cannot delete the selected columns while..." should add something like "

2) Improve workflow script to record choices chosen by user (Delete Formula --> Then Delete Columns)

//Delete columns
dt4 << Data Table( "DB.WB(Datasheet)" );	
Wait(0);
dt4:Diebond.End Date << Delete Formula;
dt4:"2nd Diebond.End Date"n << Delete Formula;
dt4:Wirebond.End Date << Delete Formula;
dt4:"2nd Wirebond.End Date"n << Delete Formula;
Wait(0);
dt4 << Delete Columns (:Diebond End Date, :"2nd Diebond End Date"n, :Wirebond End Date, :"2nd Wirebond End Date"n);

Why is this idea important? 

So that the workflow can be shared to other colleagues & running as its intended purpose.

 

 

1 Comment
GregMcMahon
Level III

I'll second this motion as I also ran into a similar problem - see topic entitled "Workflow builder and referencing"

 

Regards,

Greg