topic Re: Create new columns that add data from existing columns to one fixed column in Discussions

Create new columns that add data from existing columns to one fixed column

ashwint27 — Thu, 08 Jun 2023 16:32:18 GMT

Let's say I have one column with numeric-continuous data. This data is my "reference" data. I have n other columns with numeric-continuous data. Is there a way to create an additional n columns where each of these new columns is a sum of the first "reference" data column with each of the n other columns?

Re: Create new columns that add data from existing columns to one fixed column

brady_brady — Thu, 02 Mar 2023 02:48:10 GMT

Hi, you can do this as follows:

1) From the main menu, select Cols > New Columns... and add N columns by typing that number into the Number of Columns to add box. If you like, add them as a group and type something into the Column Prefix box.

2) Highlight all the new columns, right-click in the column header area and select "Standardize Attributes"

3) Under Column Properties, use the drop-down to select Formula:

4) Select "substitute column reference" and then click Edit Formula:

5) Enter the first formula and click OK:

6) Uncheck the reference column checkbox. The input should look like below. Then press OK.

7) The results show formulas as desired:

Cheers,

Brady

Re: Create new columns that add data from existing columns to one fixed column

ashwint27 — Thu, 02 Mar 2023 05:27:00 GMT

Thanks, this is exactly what I was trying to accomplish.