topic How to multiply column values without creating another column? in Discussions

How to multiply column values without creating another column?

UserID16644 — Wed, 13 Mar 2024 01:53:26 GMT

I have a column with decimal values that needs to be multiplied by 100. Is there other ways to do it without creating another column with formula? Is it possible to do it on the same column?

Re: How to multiply column values without creating another column?

txnelson — Wed, 13 Mar 2024 02:45:52 GMT

The easiest way to do this is to write a little script. If the name of your column that you want to change is called "The Column", the following script will

For Each Row( :The Column = :The Column * 100 );

Re: How to multiply column values without creating another column?

UserID16644 — Wed, 13 Mar 2024 05:22:31 GMT

I tried re-creating this with a For Loop, but doesn't work.

dtcols = {"Score1", "Score2"};

For( i = 1, i <= N items (dtcols), i++,
	For Each Row( dtcols[i] = dtcols[i] * 100 );
);

Re: How to multiply column values without creating another column?

txnelson — Wed, 13 Mar 2024 05:37:15 GMT

You need to tell JMP the element from the list is a column.

dtcols = {"Score1", "Score2"};

For( i = 1, i <= N Items( dtcols ), i++,
	For Each Row( As Column( dtcols[i] ) = As Column( dtcols[i] ) * 100 )
);

BTW, a simpler form to use is with a For Each() function

For Each( {col}, dtcols,
	For Each Row( As Column( col ) = As Column( col ) * 100 )
);

Re: How to multiply column values without creating another column?

UserID16644 — Wed, 13 Mar 2024 05:53:01 GMT

Thank you! I'm learning a lot ^^