Order of appearance of a set of valuesHello,
I'm looking for a JMP built-in function that I'm pretty sure it exists but I could not find.
It helped you create a new column in a datable that will affect to each row the order of appearance of a set of columns. For example, in this table, I want to count the order of appeareace of each set of values {col1, col2} :
It should give me a third column like this :
Maybe I'm wrong, but if any of you can remember a function like this one, it will help me. Thank you !
Automation and ScriptingRe: Order of appearance of a set of valuesCol Cumulative Sum(1, byvars) should work
Col Cumulative Sum(1, :Column 1, :Column 2)
Col Rank is another option which might work
Re: Order of appearance of a set of valuesWell thank you, I did find this one but had struggle using it, it works well now !
Have a great day
