Populate Column values if there is a mismatch - workaround

Rahul_Shetty

Hi All,

Is there a quick way to populate the column name if the value is a mismatch in any of the columns?

Thanks.

Example data below - 

input - 

RC	E	PG	PC	ET	A	B	C	D	E	F	G	H	I	J	K
A	B	ABC	All	De	0.7		0.7	0.7	0.7	0.7	0.25	0.7			0.7
A	B	ABC	All	De	0.7		0.7	0.7	0.7	0.7	0.25	0.7			0.7
A	B	DEF	All	De							0.25	0.7			0.7
A	B	DEF	All	De	0.4			0.4	0.4	0.4	0.25			0.4	0.4
A	B	DEF	All	De	0.4			0.4	0.4	0.4	0.25			0.4	0.4
D	BA	EFG	All	De	4			4	4	4	4.5			4	4
D	BA	EFG	All	De	4				4	4	4.5			4	4
D	BA	EFG	All	De	4			4	4	4	4.5			4	4

output - 

RC	E	PG	PC	ET	A	B	C	D	E	F	G	H	I	J	K	Values
A	B	ABC	All	De	0.7		0.7	0.7	0.7	0.7	0.25	0.7			0.7	G
A	B	ABC	All	De	0.7		0.7	0.7	0.7	0.7	0.25	0.7			0.7	G
A	B	DEF	All	De							0.25	0.7			0.7	G
A	B	DEF	All	De	0.4			0.4	0.4	0.4	0.25			0.4	0.4	G
A	B	DEF	All	De	0.4			0.4	0.4	0.4	0.25			0.4	0.4	G
D	BA	EFG	All	De	4			4	4	4	4.5			4	4	G
D	BA	EFG	All	De	4				4	4	4.5			4	4	G
D	BA	EFG	All	De	4			4	4	4	4.5			4	4	G

Yoshiro_Fujimori

@Rahul_Shetty 

Could you elaborate the definition of "mismatch in any of the columns"?

The [Values] column in your output shows "G" for all rows, but I see many other mismatches.