Script question; importing data from .txt to jmp without overwriting existing jmp data

Question

Hi all,

I have a question regarding creating a line of script, first i would like to know if it is possible and if so, is there someone who can help me create it? Since i am fairly new to the use of JMP and scripting, i appreciate all the help!

The situation is as followed;

Three times a week i collect data in a .txt file. This data is automattically imported to JMP by the use of a script.

If i want to update the JMP file with data of a new week i manually have to cut and past the data into the txt file and run the script (this to prevent duplicates in the data). What the script does is clearing the entire JMP file and refill it with the two weeks of data. Now my question is;

Is there a line of script which can import and add the new data into the already existing JMP file without overwriting the existing data?

Can this data be in a new .txt or do i have to past this underneath the already existing/loaded .txt file?

Bonus question;

Is it possible that if there are duplicates in the data, automattically one of the duplicates gets deleted?

Kind regards,

L_Kingma

uday_guntupalli · Answer

FilePath = "C:\Test.txt"; 
Save Text File(FilePath,
			    "The quick brown fox"
              ); 
Load Text File( FilePath );
Save Text File(FilePath,
			    " jumped the fence",
			    mode("append")
              ); 
Load Text File( FilePath );

You should be able to use Save Text File function to append data to an existing .txt file . 
Please see example code above . 
Relevant Post - https://community.jmp.com/t5/Discussions/Append-text-to-Save-Text-File-function/td-p/45256 
In case you meant to say append data from your .txt file to .jmp file , then 
look at Concatenate() in "Scripting Index" 
Help ==> Scripting Index ==> Concatenate

L_Kingma · Answer

Well this requires me to still copy and paste the data chronocally into my txt file. But that is more or less a nice to have. For now im really looking for a way how i can add data to the already existing JMP file, with the imput source a new .txt file, without overwriting the existing JMP data.

Is there a line of script able to do this and if so, what could it be?

Kind Regards,
L_Kingma

uday_guntupalli · Answer

Looking at the sample data - is it fair to assume that some column in the data is unique ?
So , one way I can think of is using the time columns if they are always chronological , we can use them to sort and assemble the data accordingly.

Another alternative is if your pre-existing JMP script is writing the data to a JMP file , we can try to get the time of the file creation to know the order . Those are the only two I could get .