392327_en-US

liliconcom

Using JMP Script to Populate a Column with Data

In the attached JMP data set there is a Character, Nominal "Cost Set" column.  It is not populated with Data yet. 

 

I have scrip that can populate all the cells with "ETC" :

For Each Row(:Cost Set  =  "ETC")

 

However what I would like to do is if the :Label column is equal to "May ACWP" I'd like to populate the :Cost Set column with "ACWP", otherwise the :Label column = "ETC"

 

Can someone help me with the script to do this?

 

Thanks!

 

 

ScriptingRe: Using JMP Script to Populate a Column with Data

For Each Row(
     If( :Label == "May ACWP",
          "ACWP",
          "ECT"
     );
);

Please take the time to read the new user documentation, Discovering JMP, available under the Help pull down menu.