Share your ideas for the JMP Scripting Unsession at Discovery Summit by September 17th. We hope to see you there!
Choose Language Hide Translation Bar
Highlighted
kiza
Level II

Data refresh from Excel file using JMP

So I have an Excel file in some sharepoint that is updated weekly, i do control charts with it and I know how to connect to it and do an SQL query to filter data. The problem is that I have some formulas in columns and whenever I run this process a new table is created (without those extra columns), is there a way to just refresh the data on the current table? That way the extra columns with the formulas are updated

Thanks

Article Labels

    There are no labels assigned to this post.