topic Re: How do I view the script after Standardize date format of date column in data tables? in Discussions

How do I view the script after Standardize date format of date column in data tables?

WebDesignesCrow — Fri, 09 Jun 2023 18:11:55 GMT

Hello, I'm working on joining 2 data tables (import from Excel) to JMP to be only 1 table by using scripting. End result is I would like to build an automated report (.html) with running dates (increase) on x-axis. Since the format of the dates is not same between 2 data table after import from Excel (1 is text, another 1 is numeric), my graph not sorted correctly. I've standardized the dates column all to numeric manually by clicking at the column info. If I would like to view the script after changed the column info, where can I find it? Because, for graphs we can save the graph script into window. Btw, I'm using JMP 15 and still a newbie

Re: How do I view the script after Standardize date format of date column in data tables?

frank_wang — Wed, 02 Mar 2022 08:29:45 GMT

更改列信息后的脚本在JMP15版本没有自动记录和保存的功能，具体方法可以在“脚本索引”中查找关键词“Data Type”，“Modeling Type”和"Format"，里面有JSL的语法说明是示例。（JMP16开始，日志中会记录你的所有操作过程。方便数据清洗时的脚本记录）

希望可以帮助到你 : )

Re: How do I view the script after Standardize date format of date column in data tables?

WebDesignesCrow — Thu, 03 Mar 2022 09:44:44 GMT

Thank you Frank.

Though I need to work on the column formatting scripting manually, I'm glad that JMP 16 has considered this.

Re: How do I view the script after Standardize date format of date column in data tables?

WebDesignesCrow — Mon, 14 Mar 2022 06:14:55 GMT

Actually, I have found out how to view the script for JMP 15 after we done it manually.

Click the data table name red triangle and choose copy table script (No Data). Yay.