Using JMP Script to Populate a Column with Data

[#1]

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!

[#2 · Accepted solution]

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.

[#3 · Accepted solution]

Hello Jim - Sorry for the delayed response thank you for providing the script for this - Dan F.

[#4 · Accepted solution]

:Cost Set << Set Each Value( If( Contains( (:label column << Get Name ), "ACWP" ), "ACWP", "ETC" ) )

[#5]

Hello Mark - Sorry for the delayed response thank you for providing the script for this - Dan F.