Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Data:
load
Reference,
Amount,
Name,
maxstring(Description) as Description
Country,
Domicile
FROM Source
Group by
Reference,
Amount,
Name,
Country,
Domicile;
Data:
load
Reference,
Amount,
Name,
maxstring(Description) as Description
Country,
Domicile
FROM Source
Group by
Reference,
Amount,
Name,
Country,
Domicile;