I have a table where in a certain column a limited number of labels (customers) is used. The number of rows is much bigger then the number of labels. So, each customer label is used several times complemented with other data which is unique for each row.
The problem I have is how to get in a new table a list of the unique labels (all the customers) where each row contains only one customer.
I managed to get a select list where I could select one out of the total list of customers.
But I need to get it generated for me.
I tried [Table 1].Customer.Unique() but that produced in each row a list of all the customers.