549436_en-US

liliconcom

Datatable indexing Problem within a Formula

I am trying to apply the log10 function to an entire column within a data table.  The result will be in a new column with a new name.  The new column and name are generated by I get an error in the formula portion.  Below are the results of the script and the error message.

 

This is the script:

 

Names Default To Here(1);
dt = As Table(J(5, 5, Random Uniform()), <<COLUMN names=""></COLUMN>

 

Thanks for your help in advance.

Ray

Quality and Process EngineeringSharing and Communicating ResultsRe: Datatable indexing Problem within a Formula

You need to evaluate the column name into the formula. This is a good post about it Insert one expression into another using Eval Insert, Eval Expr, Parse, and Substitute 

Re: Datatable indexing Problem within a Formula

Here's just the script.  But definitely the article is more in depth.  

 

Names Default To Here(1);
dt = As Table(J(5, 5, Random Uniform()), <<COLUMN names=""></COLUMN>