Subscribe Bookmark RSS Feed

How to combine data into one jump file

hs

Community Trekker

Joined:

Sep 9, 2011

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

HS

1 ACCEPTED SOLUTION

Accepted Solutions
Solution

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.

2 REPLIES
Solution

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.

hs

Community Trekker

Joined:

Sep 9, 2011

Thanks much, that was easy, as I expected.

HS