topic Re: Order of appearance of a set of values in Discussions

Order of appearance of a set of values

CorentinL — Wed, 15 May 2024 10:43:16 GMT

Hello,

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 !

Re: Order of appearance of a set of values

jthi — Wed, 15 May 2024 10:50:02 GMT

Col 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 values

CorentinL — Wed, 15 May 2024 12:43:27 GMT

Well thank you, I did find this one but had struggle using it, it works well now !

Have a great day