Exclude rows

[Sir_12345]

Hi all,

I have this table and I want to exclude the pair of transactions where the one transaction is R and the other one is T, for each Customer that makes transaction in the same Branch at the same Date, when the Purchase is equal to Sale and vice versa at the corresponding rows. The same applies to CurrencyPur and CurrencySale.

I need to exclude only the pair of the transactions that have the above criteria. Do you have any ideas??

Thanks in advance!

[qv_testing]

It would be great if you could provide sample data.

[Anil_Babu_Samineni]

@Sir_12345 

I Assume Transaction here meaning Event.
Load Distinct
All columns here
From Table
Where Not Match(Event, 'T', 'R') and Purchase=Sales and CurrencyPur=CurrencySale;

PS. Here for this "or each Customer that makes transaction in the same Branch at the same Date", The distinct will deserve by default.