There are multiple TXT format table data in the same path, but I only import one file into JMP at a time.
Since each TXT file has different column names and number of columns, how to use JSL to unify the data to be imported from column 8 to the last column to be set to consecutive number format?Thank you very much!
I think this way of recording with JMP is too complicated.
I would suggest that you try just using the Open() function with just the path as input. That way, JMP will use the defaults, and examine the file and open the table. You can then use your JSL to determine what has been input, and to modify the data table down to what you need.
I would like a bit more detail on what you mean by "troublesome". Having JMP parse across a data table with lots of blank columns, and determining which ones to delete, etc. ia a relatively easy thing to do. So in the past, I have typically taken this approach.
There are no labels assigned to this post.