How do I get the import file settings right before transposing and joining two files by script?
I have two sources of data that I need to put together and create a master tabel for analysis and reporting.One is in .csv (Resulst 1) and another is in .xlsx (Results 2) format. The file in .xlsx format I need to specify individual worksheet settings and which sheet to open when importing. I have seen the following posts but have not managed to get it to work:https://community.jmp.com/t5/JMP-Scri...