topic Re: New Column to show repeated values in for each run/ID across two data types in Discussions

New Column to show repeated values in for each run/ID across two data types

VT23 — Fri, 15 Mar 2024 18:18:10 GMT

I tried using lag function to indicate when the first test for a sample ID based on time column. Need to the column, Order Tested, to represent first test conducted for a sample ID and second test based on time. Each test will have a real and maybe a code value. See attached file for JMP file. At the end of the day Order Tested column needs to look like image below. This is just a sample, real one has 10,000+ data points.

Re: New Column to show repeated values in for each run/ID across two data types

jthi — Fri, 15 Mar 2024 18:56:20 GMT

You can use Col Cumulative Sum with if statement

Col Cumulative Sum(If(Row() == Col Min(Row(), :Sample ID, :Time, :DataType), 1, .), :Sample ID, :DataType)

Kudos to make this much much easier

Re: New Column to show repeated values in for each run/ID across two data types

VT23 — Fri, 29 Mar 2024 15:59:43 GMT

Thanks for the solution!