nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

748755_en-US

liliconcom

How to copy paste a formula column between two different tables

I have two tables coming from two similar files that vary in number of rows.

They share column names and I want to copy-paste formula columns from the old one to the new one.

There is no index I can use to join them.

How can I do that, ideally without JSL?

Automation and Scripting

Re: How to copy paste a formula column between two different tables

Copy Columns on first table (right click on column header and select Copy Columns) and Paste Columns on second table should work (right click somewhere on column header and select Paste Columns).

Re: How to copy paste a formula column between two different tables

Thanks. It didn't seem to work using the Edit menu. Clicking on the headers was the trick.

Re: How to copy paste a formula column between two different tables

Can this be scripted? the Equivalent of Selecting the column header, then Ctrl+C, selecting the other header and Ctrl+V?

Re: How to copy paste a formula column between two different tables

Most likely yes but the method might be slightly different from copy+paste in the script.

Comments

There are no comments yet