362865_en-US

liliconcom

Function in script to get log of a column

Hello,

I was wondering how I would go about taking the log10 of a few of my columns and then having the data posted.

E.g. For Column X, take the values (Y) and perform log10(Y) and save values under Column X Log

Data TableRe: Function in script to get log of a column

If I understand you correctly, this is quite easy.  Create the new column logX.  Create a formula for the column (right click on the column and select Formula).  In the left column select Transcendental and you will see log10 option.  Simply put the column you want to transform in the parentheses.

 

Re: Function in script to get log of a column

Hi @SI-2000 

for me the fastest way would be to select the columns you want to transform right click them and follow the menu in the picture: New formula column >> transform >> log

you can do that to as many columns you select in one go.

let us know if it works for you,

ron