topic Re: Using JMP Script to Populate a Column with Data in Discussions

Using JMP Script to Populate a Column with Data

dfusco923 — Fri, 09 Jun 2023 19:49:06 GMT

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!

Re: Using JMP Script to Populate a Column with Data

txnelson — Thu, 10 Jun 2021 14:35:54 GMT

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.

Re: Using JMP Script to Populate a Column with Data

Mark_Bailey — Thu, 10 Jun 2021 16:23:42 GMT

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

Re: Using JMP Script to Populate a Column with Data

dfusco923 — Sun, 20 Jun 2021 13:22:27 GMT

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

Re: Using JMP Script to Populate a Column with Data

dfusco923 — Sun, 20 Jun 2021 13:24:10 GMT

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