show the updated details where rows are not matching

[manojkumar_mk]

Hi Qlik Experts,

I am struck with one scenario where i need to show unmatched columns details if rows are not matching.

Please have a look into below table for more clearing:

	Input							Output
	Deal NO	Unit	Payment	Event Deal Tracking Number	Ins Type	Toll Set	Buy Sell	Field Name	Old Value	New Value
	1011	BBL	Invest	3768	Commodity	Comopt	Sell
	1011	BBL	Invest	3768	Commodity	Comopt	Sell	Payment	Invest	Price
	1011	BBL	Price	3768	Commodity	Comopt	Sell
	2022	PTL	Interest	78643	EO-Call	Commodity	Buy
	2022	PTL	Interest	78643	EO-Call	Commodity	Buy
	2022	PTL	Interest	78643	EO-Call	Commodity	Buy	Unit	PTL	BBL
	2022	BBL	Interest	78643	EO-Call	Commodity	Buy
	5467	PTLCL	Premium	65732	Comm-Phys	CommFut	Sell
	5467	PTLCL	Premium	65732	Comm-Phys	CommFut	Sell
	5467	PTLCL	Premium	65732	Comm-Phys	CommFut	Sell	Ins Type	Comm-Phys	Comm-Fee
	5467	PTLCL	Premium	65732	Comm-Fee	CommFut	Sell
	5467	PTLCL	Premium	65732	Comm-Fee	CommFut	Sell
	5467	PTLCL	Premium	65732	Comm-Fee	CommFut	Sell
Condition:	we should show output where the rows are different for each deal number  if rows are matching no need to show

Please help with your valuable suggestions.

Thanks in Advance..!!