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..!!