nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Adressing columns in reports generated by workflows

Jo_E

I am getting data in a standardized excel file and use a JMP workflow to load this file into JMP. The workflow generates additional columns and does some calculations to prepare the data set for visual presentation. This part is working well. My idea was to integrate into the workflow some reports to get graphs showing the data. I prepared the reports and saved these in a recorded workflow session to the project. If I start now and let the workflow run, the reports appear, but these reports lost the link to the columns and consequently the graph does not work. And as the excel file is standardize the column order and names are always the same.
It would be great if someone has a recommendation how I could solve this and adress the columns in a way that it remains in the reports after running the workflow.

Accepted answers

Jo_E

Thank you for your reply. What I was talking about is shown in the code snippet below. In the script for generating the graphs X and Y were directly specified to a certain colum e.g. Y to :SEC and X to :Storage Time. But by saving the script to the table generated by the workflow the As Column() part appears instead of this.

In general I would like to have a solution to run in the workflow a skript I generated elsewhere before.

I really hope to make it easier for you to understand my issue.

Bivariate(
		SendToByGroup( {:Temperature == 5} ),
		Y( As Column() ),
		X( As Column() ),
		By( :Temperature ),
		SendToByGroup(
			{:Temperature == 5},
			SendToReport(

jthi

How do you save the workflow script to data table? Usually the scripts generated by Workflow builder do look something like this (for single step)

And the whole script does include few extra things

Names Default To Here(1);


Workflow_=function({}, 
    step_name = "Report snapshot: Big Class - Distribution of height, weight";
    //Report snapshot: Big Class - Distribution of height, weight
    Data Table("Big Class") << Distribution(
    	Continuous Distribution(Column(:height), Process Capability(0)),
    	Continuous Distribution(Column(:weight), Process Capability(0))
    );
);
Workflow_();

Also sharing example data / workflow (or both) could definitely help. If you are not willing to share them to JMP Community, I would suggest you contact JMP Support

All comments

jthi

I don't really use workflow builder but to my knowledge it is quite good at tracking columns and will also ask you if some columns are missing.

If you look at the script created by workflow, does it have the correct columns in the report script? What do you mean by breaking the link? Does JMP ask you which columns to use for the reports? Which platforms you use to create said columns? Is Workflow builder able to record those platforms properly?

Ben_BarrIngh

@Jo_E ,

You say you saved the session to a project, do you mean a JMP Project? It's hard to say what's wrong without some data to look at - could you send over the workflow and a dummy excel data sheet to look at?

As @jthi mentioned, the Workflow Builder is good at noticing when a column is missing and will prompt the user to pick a replacement.

Thanks,

Ben

Jo_E

In general I would like to have a solution to run in the workflow a skript I generated elsewhere before.

I really hope to make it easier for you to understand my issue.

Bivariate(
		SendToByGroup( {:Temperature == 5} ),
		Y( As Column() ),
		X( As Column() ),
		By( :Temperature ),
		SendToByGroup(
			{:Temperature == 5},
			SendToReport(

jthi

How do you save the workflow script to data table? Usually the scripts generated by Workflow builder do look something like this (for single step)

And the whole script does include few extra things

Names Default To Here(1);


Workflow_=function({}, 
    step_name = "Report snapshot: Big Class - Distribution of height, weight";
    //Report snapshot: Big Class - Distribution of height, weight
    Data Table("Big Class") << Distribution(
    	Continuous Distribution(Column(:height), Process Capability(0)),
    	Continuous Distribution(Column(:weight), Process Capability(0))
    );
);
Workflow_();

Also sharing example data / workflow (or both) could definitely help. If you are not willing to share them to JMP Community, I would suggest you contact JMP Support

Jo_E

I generated the skript to make a graph with the selected colums and recorded in the workflow that I save these to the table. This works initally, but if I use the recorded workflow next time the column referencing of the Graph script is messed up and I do not understand why.