topic Re: Combine stacked tables in Discussions

Combine stacked tables

UserID16644 — Sat, 10 Jun 2023 23:34:38 GMT

hi all,

I have stacked a table 12 times. Now I want to combine all the tables into one file. Is it possible? I tried concatenate but other columns where not being included. Is there any other ways to do this? Thanks!

Re: Combine stacked tables

txnelson — Tue, 03 Aug 2021 01:09:46 GMT

I do not understand what you mean when you say " I tried concatenate but other columns where not being included". I am also confused as to why you would have to stacked a table 12 different times.

Would it be possible if you could provide more specifics on the steps you are taking, and what your desired results are?

Re: Combine stacked tables

UserID16644 — Tue, 03 Aug 2021 01:28:18 GMT

I stacked the table 12 times because I needed to get 12 different parameter values. Then I need it all to be combined in one table

Re: Combine stacked tables

txnelson — Tue, 03 Aug 2021 02:23:06 GMT

If you do 12 stacks and create 12 new tables, by default, you will have columns called Label and Data in each of the 12 data tables. If you concatenate all 12 data tables, JMP will effectively stack those 2 columns on top of each other in the new table. It sounds like that is not what you want. What is the result you want?

Re: Combine stacked tables

UserID16644 — Tue, 03 Aug 2021 03:53:00 GMT

I renamed the Label and Data per table according to the parameters needed. However, when I concatenate those data tables, so many blanks cells were added because of the different column name. I think concatenate is not the appropriate thing to use. I just wanted all the columns to be in one file, without blanks cells because it affects my bivariate plot.

Re: Combine stacked tables

txnelson — Tue, 03 Aug 2021 03:55:24 GMT

Then you may want to use Update, or Join, if there are justifications on which rows for the different tables are related to each other.