581876_en-US

liliconcom

Group multiple column

Hi,

 

I'm novice in JMP. Starting to learn JMP. I'm trying to group a column and count the number of row.

Below is the example to clarify my question.  Basically i have 4 unit tested with different pattern. Each pattern will output failure.

How can i group them based on pattern. Any help will be appreciated. Thanks

 

Example raw data:

	TEST A	TEST A FAIL OUTPUT	TEST B	TEST B FAIL OUTPUT	TEST C	TEST C FAIL OUTPUT
UNIT A	A0 PATTERN	A1
UNIT B	A0 PATTERN	A2	B0 PATTERN	B1	C0 PATTERN	C1
UNIT C	A0 PATTERN	A1	B1 PATTERN	B2
UNIT D			B1 PATTERN	B3	C0 PATTERN	C2

 

Output needed:

A0 PATTERN	A1	2
	A1	1
B0 PATTERN	B1	1
B1 PATTERN	B2	1
	B3	1
C0 PATTERN	C1	1
	C2	1

 

 

Data Table