Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am doing a left join from file A to file B. For each unique identifier however in file B there are duplicate sales amounts. I only want to join where the sales amounts are unique for each identifier. How would I go about doing this ?
Hello Sid,
As you have done Sum(Amount) above... similarly you can do Max(Quantity) aggression and join it with Table A.
Please mark, comments as 'Correct' or 'Helpful'.