REMOVE DUPLICATED BASED ON DIFFERENT ROWS

[REIX]

How do i write a qvd to remove duplicates , UNIQUE_ID  is unique , and SALE_ID and other values are duplicated forexample the highlighted STORE B , want to retrieve only one row using QVD.

[LRuCelver]

Group by all fields that have been duplicated and use an aggregation function (such as FirstValue) for the others:

Data:
NoConcatenate Load
	STORE,
    AGENT_ID,
    FirstValue(UNIQUE_ID) as UNIQUE_ID,
    NUMBER,
    LOCATION,
    Date,
    Month,
    AMOUNT,
    TYPE
From [...]
Group By
	STORE,
    AGENT_ID,
    NUMBER,
    LOCATION,
    Date,
    Month,
    AMOUNT,
    TYPE
;