topic Re: How to combine data into one jump file in Discussions

How to combine data into one jump file

hs — Fri, 09 Sep 2011 13:26:34 GMT

I am new to using Jump so I assume this is a basic question. I have approximately five different jump files with data. I would like to combine all the data into one file and create a script to show all the data on one graph. I attached the files I would like to combine.

Thanks

Re: How to combine data into one jump file

louv — Fri, 09 Sep 2011 14:07:33 GMT

First of all make sure all of your columns have consistent names then simply open all of your files and use the Tables>Concatenate capability in JMP. I renamed your columns A, B, C, D, E, F to simplify and then just concatenated them in order using the dialog box test1, test2, test3, test4, test5 and obtained a combined table with all of your 1,035,487 records. I also checked the feature to add a column for the source as well as the maintain column formulas.

Re: How to combine data into one jump file

hs — Fri, 09 Sep 2011 14:31:01 GMT

Thanks much, that was easy, as I expected.