How to export unique value in found cound

Discussion created by aanshi on May 17, 2016
Latest reply on May 17, 2016 by beverly

I have a table called asset where there is one field called Location.

I am finding newly created records. lets say in this found cound there are below records.


Assetid Location      Model

1          Bedroom1    7845

2          Other           1285  

3          Other           1302   

4          bedroom1    4520


I want to export unique locations .

Output should be





How to perform this ?