topic Copy and Paste multiple column headers? in Discussions

Copy and Paste multiple column headers?

AllenJH — Sat, 10 Jun 2023 23:23:51 GMT

Hi Everyone!

I'm new to JMP (v14 here), so I apologize if this has been asked before. I'm attempting to concatenate some data files (csv) and multiple import is working fairly well... I will have duplicates to take care of as well as some column differences... I may end up with a powershell concatenate without worrying about this import in jmp, but I thought I'd try jmp first.

In a few of the files, I've found a lack of first line header info. So, if I chose to use the first line as a header, the data finds itself as the column names in the jmp data table. An easy solution to this would be to insert a line, copy in the header line into the first line... but then I'm at a loss as to how to actually copy and paste the header "row"... is there a way to manipulate the headers all together and not select all the columns' rows at the same time?

Thanks again for your help and suggestions!!

-Allen

Re: Copy and Paste multiple column headers?

AllenJH — Thu, 17 Dec 2020 20:30:23 GMT

I've turned to powershell to brute-force concatenate. JMP's multiple file read and table concatenation is definitely smart here- but I think I will clean up the data after cat'ing and filtering.

Would love to know if there's an easy way to apply/copy the header values between tables though! I know it's not excel ;) but this seems like a fairly common operation to perform.

Thanks for any and all input/suggestion! Cheers!

Re: Copy and Paste multiple column headers?

txnelson — Thu, 17 Dec 2020 20:54:25 GMT

This can be done, by selecting all of the column headers in the columns panel you want to copy, go to the Edit pull down menu and select Copy. Then go to the data table you want to copy the headers to and select in the column panel, the columns you want to paste into, and then go to Edit=>Paste pull down menu.

Re: Copy and Paste multiple column headers?

jules — Thu, 17 Dec 2020 21:34:36 GMT

Hi @AllenJH,

You can copy the column headers by selecting the columns in the columns list on the left, and then copying with Edit > Copy As Text (not Edit > Copy). Then, select the first row and then Edit > Paste.

In JMP 16 (available 2021) there are built-in utilities for situations like this available under Cols > Column Names >. For earlier versions of JMP, I highly recommend @MikeD_Anderson 's Add-In, which adds these same utilities.

So why not Edit > Copy? Edit > Copy returns text in rows, which is useful when you're copying column names from one table to another. Edit > Copy As Text will return a tab delimited list, which is good for this particular case where what you are asking jmp for is the transpose of your columns list.

Result from Edit > Copy
5.1
3.5
1.4
0.2
setosa

Result from Edit > Copy As Text
5.1	3.5	1.4	0.2	setosa

I hope this helps!

@jules

Re: Copy and Paste multiple column headers?

Jeff_Perkinson — Fri, 18 Dec 2020 20:21:27 GMT

@jules is demonstrating a variant from That's nice.

Re: Copy and Paste multiple column headers?

AllenJH — Sat, 19 Dec 2020 03:50:30 GMT

Thanks! It appears I had also multiple issues- one was data in a column header position, but another was actually empty column headers that needed the same as another data table for cat'ing (hence the need to copy and paste the header names themselves). The add-in was a nice addition to my JMP14 version- thanks for that pointer!

Re: Copy and Paste multiple column headers?

AllenJH — Sat, 19 Dec 2020 03:50:56 GMT

Thanks for the reply and solution!!

Re: Copy and Paste multiple column headers?

zhaoyjjmp — Mon, 28 Oct 2024 14:58:34 GMT

I am using ver17. There is no copy as in ver17. Any new solution for ver17?

Thanks

Jay