How do I find rows with the same values for any two columns in a given column?
For example, columns 1 —— 3 here:dt = Open( "$SAMPLE_DATA\Missing Data Pattern.jmp" );
dt<<New Column("T1",formula(If( As Column( 1 ) == As Column( 2 ) | As Column( 2 ) == As Column( 3 ) | As Column( 1 ) == As Column( 3 ), 1)));dt<<run formulas;Column("T1")<<deleteFormula;
Thanks!