BookmarkSubscribeRSS Feed
hs

Community Trekker

Joined:

Sep 9, 2011

How to combine data into one jump file

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
louv

Staff

Joined:

Jun 23, 2011

Solution

Re: How to combine data into one jump file

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
louv

Staff

Joined:

Jun 23, 2011

Solution

Re: How to combine data into one jump file

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

Re: How to combine data into one jump file

Thanks much, that was easy, as I expected.

HS