Hi JMP community,
I am trying to make one script button concatenate "PV800_App1_Trend_1_Datalog.csv" with "PLC_DATA_MASTER.jmp" into "CONCATENATED_PLC_DATA.jmp" and then save the concatenated file over the original "PLC_DATA_MASTER.jmp"
The reason is that I have a USB flash drive with industrial PLC data, and this script can automatically update the new data that the PLC logs, and then keep the master file up to date. Everything works, except saving the file. I am even sure that I have dt4 assigned correctly to "CONCATENATED_PLC_DATA" because I have tested close(dt4) but for some reason, any type of script to save the file gives me various error messages.
This script gives me
Send Expects Scriptable Object in access or evaluation of 'Send' , dt4 << /*###*/save(
"C:\Users\Jeffrey\Documents\Data Connections\PLC_DATA_TERLOTHERM\PLC_DATA_MASTER.jmp"
) /*###*/
Here is the script. It won't save the concatenated over the master, and gives me the error message above, which I do not understand. Thanks, team.
dt2=open("C:\Users\Cheesemaker\Documents\Data Connections\PLC_DATA\PLC_DATA_MASTER.jmp"); \\ open master dataset
dt3=open("C:\Users\Cheesemaker\Documents\Data Connections\PLC_DATA\PV800_App1_Trend_1_Datalog.csv"); \\ open new dataset
dt3 << Select Where(Time == "Time"); \\ filter out text rows
dt3 << Delete Rows;
column(dt2,"Time")<<DATA type=""></DATA>
I believe your code will work if you change the line
dt4=("CONCATENATED_PLC_DATA");
to
dt4=data table("CONCATENATED_PLC_DATA");
