I'm looking for a way to execute a script across multiple data tables by executing the script once as opposed to executing the script one time per data table.
Current Data Flow
- Open reference JMP data table.
- Use a 1st script (based on Multiple File Import) to import multiple excel files into multiple JMP data tables (1 Table Per File).
- Result: 1 Reference Data Table Open and 2-10+ new JMP Data Tables from import script.
- Run a 2nd script on each created JMP DataTable to clean up the data and update the created data tables with data from the reference JMP data table.
- Result: 1 Reference Data Table and 2-10+ JMP data tables that have been cleaned up (delete columns, add calculated columns, etc) and have been updated (scripted Update data table) with data from the reference data table.
I'd like to find a solution where I don't have to manually apply my 2nd script individually to each created JMP Data Table.
I'm open to any approaches.
I've thought about trying to use JMP lists and/or the "For Each" function but I haven't been able to find examples of applying these to data tables. I think I would need to make a list of all open data tables filtered by their name (so I can filter out the reference data table I use to update the data tables of interest), I also don't know how to do this.
Thank you for any and all advice and ideas.
