cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Browse apps to extend the software in the new JMP Marketplace
%3CLINGO-SUB%20id%3D%22lingo-sub-800448%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3EAjouter%20une%20colonne%20de%20r%C3%A9sultats%20en%20fonction%20de%20diff%C3%A9rents%20r%C3%A9sultats%20de%20regroupement%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-800448%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EJe%20ne%20suis%20pas%20s%C3%BBr%20que%20cela%20soit%20possible.%20J'essaie%20d'ajouter%20une%20colonne%20de%20r%C3%A9sultat%20final.%20Dans%20ce%20cas%2C%20je%20souhaite%20afficher%20le%20premier%20mode%20d'%C3%A9chec.%20De%20plus%2C%20si%20l'appareil%20r%C3%A9ussit%20lors%20d'un%20nouveau%20test%2C%20j'ai%20besoin%20d'une%20r%C3%A9ussite%20en%20tant%20que%20r%C3%A9sultat.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22ConfidenceOwl94_0-1726767229729.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22ConfidenceOwl94_0-1726767229729.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22ConfidenceOwl94_0-1726767229729.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22ConfidenceOwl94_0-1726767229729.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22ConfidenceOwl94_0-1726767229729.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22ConfidenceOwl94_0-1726767229729.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22ConfidenceOwl94_0-1726767229729.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F68462i5F571EAE3540BDB7%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22ConfidenceOwl94_0-1726767229729.png%22%20alt%3D%22ConfidenceOwl94_0-1726767229729.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-800448%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CLINGO-LABEL%3EAcc%C3%A8s%20aux%20donn%C3%A9es%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-800462%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3ERe%3A%20Ajouter%20une%20colonne%20de%20r%C3%A9sultats%20en%20fonction%20de%20diff%C3%A9rents%20r%C3%A9sultats%20de%20regroupement%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-800462%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%3CP%3EEst-il%20possible%20que%20SN%20soit%20retest%C3%A9%20de%20bon%20%C3%A0%20mauvais%20%3F%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3EModifier%3A%3C%2FP%3E%0A%3CP%3EEn%20partant%20du%20principe%20qu'il%20n'y%20a%20pas%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3ENames%20Default%20To%20Here(1)%3B%0A%0Adt%20%3D%20Open(%22%24DOWNLOADS%2FSample1.jmp%22)%3B%0Adt%20%26lt%3B%26lt%3B%20new%20column(%22OK%22%2C%20Character%2C%20Nominal%2C%20Formula(%0A%09If(Col%20Max(Col%20Sum(%3ABin%20%3D%3D%20%22Pass%22%2C%20%3ASN%2C%20%3ARun)%2C%20%3ASN)%20%3D%3D%20Col%20Number(%3ASN%2C%20%3ARun)%2C%0A%09%09%22Pass%22%0A%09%2C%0A%09%09%3ABin%5BCol%20Min(If(%3ABin%20!%3D%20%22Pass%22%2C%20Row()%2C%20.))%5D%3B%0A%09)%3B%0A))%3B%0A%0A%0Adt%20%3D%20Open(%22%24DOWNLOADS%2FSample2.jmp%22)%3B%0Adt%20%26lt%3B%26lt%3B%20new%20column(%22OK%22%2C%20Character%2C%20Nominal%2C%20Formula(%0A%09If(Col%20Max(Col%20Sum(%3ABin%20%3D%3D%20%22Pass%22%2C%20%3ASN%2C%20%3ARun)%2C%20%3ASN)%20%3D%3D%20Col%20Number(%3ASN%2C%20%3ARun)%2C%0A%09%09%22Pass%22%0A%09%2C%0A%09%09%3ABin%5BCol%20Min(If(%3ABin%20!%3D%20%22Pass%22%2C%20Row()%2C%20.))%5D%3B%0A%09)%3B%0A))%3B%0A%0AWrite()%3B%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3ECela%20cr%C3%A9era%20pour%20vous%20une%20colonne%20%C2%AB%26nbsp%3BOK%26nbsp%3B%C2%BB%20%C3%A0%20partir%20de%20laquelle%20vous%20pourrez%20obtenir%20la%20formule%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3EIf(Col%20Max(Col%20Sum(%3ABin%20%3D%3D%20%22Pass%22%2C%20%3ASN%2C%20%3ARun)%2C%20%3ASN)%20%3D%3D%20Col%20Number(%3ASN%2C%20%3ARun)%2C%0A%09%22Pass%22%2C%0A%09%3ABin%5BCol%20Min(If(%3ABin%20!%3D%20%22Pass%22%2C%20Row()%2C%20.))%5D%0A)%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-800526%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%3A%20Ajouter%20une%20colonne%20de%20r%C3%A9sultats%20en%20fonction%20de%20diff%C3%A9rents%20r%C3%A9sultats%20de%20regroupement%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-800526%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EOui%2C%20vous%20avez%20raison.%20Cela%20ne%20devrait%20pas%20%C3%AAtre%20possible.%20Mais%20c'est%20possible%20en%20raison%20d'une%20erreur%20du%20testeur%20ou%20d'un%20instrument%20avec%20un%20faible%20GRR.%20Les%20chances%20sont%20vraiment%20faibles%20et%20nous%20pouvons%20ignorer%20cette%20possibilit%C3%A9%20pour%20le%20moment.%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3CP%3ELa%20solution%20que%20vous%20avez%20donn%C3%A9e%20a%20fonctionn%C3%A9%20pour%20l'exemple%20donn%C3%A9.%20Mais%20lorsque%20je%20l'ai%20appliqu%C3%A9e%20%C3%A0%20plusieurs%20SN%2C%20cela%20n'a%20pas%20fonctionn%C3%A9.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22ConfidenceOwl94_0-1726774872351.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22ConfidenceOwl94_0-1726774872351.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22ConfidenceOwl94_0-1726774872351.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F68475i4C9476C36F9EA633%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22ConfidenceOwl94_0-1726774872351.png%22%20alt%3D%22ConfidenceOwl94_0-1726774872351.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-800527%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%3A%20Ajouter%20une%20colonne%20de%20r%C3%A9sultats%20en%20fonction%20de%20diff%C3%A9rents%20r%C3%A9sultats%20de%20regroupement%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-800527%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EIl%20pourrait%20suffire%20d'ajouter%20%3ASN%20au%20r%C3%A9sultat%20et%20de%20modifier%20l%C3%A9g%C3%A8rement%20le%20num%C3%A9ro%20de%20colonne%20(ou%20mieux%20encore%20de%20le%20changer%20en%20somme%20de%20colonnes%20de%20un)%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3EIf(Col%20Max(Col%20Sum(%3ABin%20%3D%3D%20%22Pass%22%2C%20%3ASN%2C%20%3ARun)%2C%20%3ASN)%20%3D%3D%20Col%20Number(1%2C%20%3ASN%2C%20%3ARun)%2C%0A%09%22Pass%22%0A%2C%0A%09%3ABin%5BCol%20Min(If(%3ABin%20!%3D%20%22Pass%22%2C%20Row()%2C%20.)%2C%20%3ASN)%5D%0A)%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%3CCODE%20class%3D%22%20language-jsl%22%3E%3C%2FCODE%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar
ConfidenceOwl94
Level III

Add result column based on diffent binning result

I am not sure if this is even possible. I am trying to add final result column. In that I want to output first failure mode. Also if device pass in a retest I need pass as a result.

ConfidenceOwl94_0-1726767229729.png

 

3 REPLIES 3
jthi
Super User

Re: Add result column based on diffent binning result

Is it possible that SN is retested from good to bad?

 

Edit:

Going with the assumption of no

Names Default To Here(1);

dt = Open("$DOWNLOADS/Sample1.jmp");
dt << new column("OK", Character, Nominal, Formula(
	If(Col Max(Col Sum(:Bin == "Pass", :SN, :Run), :SN) == Col Number(:SN, :Run),
		"Pass"
	,
		:Bin[Col Min(If(:Bin != "Pass", Row(), .))];
	);
));


dt = Open("$DOWNLOADS/Sample2.jmp");
dt << new column("OK", Character, Nominal, Formula(
	If(Col Max(Col Sum(:Bin == "Pass", :SN, :Run), :SN) == Col Number(:SN, :Run),
		"Pass"
	,
		:Bin[Col Min(If(:Bin != "Pass", Row(), .))];
	);
));

Write();

This will create "OK" column for you from which you can get the formula

If(Col Max(Col Sum(:Bin == "Pass", :SN, :Run), :SN) == Col Number(:SN, :Run),
	"Pass",
	:Bin[Col Min(If(:Bin != "Pass", Row(), .))]
)
-Jarmo
ConfidenceOwl94
Level III

Re: Add result column based on diffent binning result

Yes, you are right. It should not be possible. But it is possible because of tester error or instrument with poor GRR. Chances are really low and we can ignore that possibility for now.

 

Solution you gave did work for the given example. But when I applied it to with multiple SN, It did not worked. 

ConfidenceOwl94_0-1726774872351.png

 

jthi
Super User

Re: Add result column based on diffent binning result

It might be enough if you add :SN to the result and modify Col Number slightly (or even better change it to col sum of one)

If(Col Max(Col Sum(:Bin == "Pass", :SN, :Run), :SN) == Col Number(1, :SN, :Run),
	"Pass"
,
	:Bin[Col Min(If(:Bin != "Pass", Row(), .), :SN)]
)

-Jarmo