Distinct

[raadwiptec]

I have the following Fields in my Source

Reference|Amount|Name|Description|Country|Domicile

I Need to have the Distinct values Only For the Below fields excluding  'description' Column. But in the Output finally I need the Description Column to be included after taking the unique values

Reference|Amount|Name|Country|Domicile 

Thanks to suggest.

[Kushal_Chawda · Accepted solution]

Data:
load
Reference,
Amount,
Name,
maxstring(Description) as Description
Country,
Domicile
FROM Source
Group by
Reference,
Amount,
Name,
Country,
Domicile;