Workflow builder

[#1]

Hi, I want to automate the Load of data from Excel and set Speclimits to the loaded Columns. I have the limits in Limits Files. The script that I created with the Workflow builder stops in the "Manage Limits" Window where I can eighter enter the limits or load the limits file. Typing is not recorded, as well as loading the limit file does not work.

The error code is attached as picture as well as the stopping Window.

Any help is very appreciated.

Many thanks

Peter 

[#2]

Manage Spec limits is one platform which has quite a few features which aren't being captured by action recorder so you might have to take a peek to Scripting Index and Manage Limits

This most likely gives quite good of an idea what you can do. Then you can create a custom step in workflow builder and utilize this example. You might also want to see all options for the Manage Limits (category on the left and filter empty) to see how to set those specification limits after they have been loaded

[#3]

Hello Jthi,

Thanks, I understand how you want to tackle the read in of the spec Limits. Unfortunately my scripting skills are that low, I get always error messages.

May be you or someone else is able to write the script for me.

My DataTable is already open.

I need to open the Limits Table.

I need to join the Limits with the process variables in my Data table and then

I need to save the Datatable with the added Limits. 

I attached one example of Files that I have to enrich with Spec limits.

Thanks

Peter

[#4 · Accepted solution]

I'm not sure where I'm supposed to know which are all of your your process variables, so I just took all continuous columns from your limits table

Names Default To Here(1);

dt = Open("$DOWNLOADS/MC_After_ Hard.jmp");
dt_limits = Open("$DOWNLOADS/Limits_MC_After_Hard.jmp");

processnames = dt_limits << Get Column Names("Continuous", String);

ml = dt << Manage Limits(
	Process Variables(Eval(processnames)),
	Load From Limits Table(dt_limits)
);
ml << Save to Column Properties;

ml << Close Window;

[#5]

Hello Jthi,

That was the push I needed. MANY THANKS

Peter