Hi All,
I am using Application Builder to develop a tool for data analytics with Python integration. I have created a button to export a user's parameter selections in case they want to re-upload those at a later time and perform the same data preprocessing. Currently, the way I export the parameters is I first script them to a csv (using Save Text File(...) ), then it can be opened as a jmp table and from there, the two columns (Variables and Values) can be set to an Associative Array and I also save that as a JSON file for use in a backend application. I have included a picture of what the exported jmp table might look like (for Variables 9 and 10, depending on the selection, there may be one, two, or three additional variables, so the table (and associative array/json) are not always the same size. Some of the values are strings and others are numbers.
My question is how can I best re-upload these parameters (preferably from both the jmp table and also from the JSON file) so that the variables are properly set to their values and can be used in later calculations. I have been playing around with For Each(...) from the Associative Arrays, but have not been able to set the variables properly. This is not the most straightforward way to save the parameters, but I was unable to figure out how to get the variables and values properly scripted to be sent directly to a jmp table. The current method I'm using to save parameters works for my purposes, but if another method or if if changing the structure/layout of the csv/table would make the uploading of the parameters easier, I am open to suggestions.
Thanks for any help.