Extracting a UNIQUE() Column from another table

[Reji1234567]

Hi Everyone,

I would like to ask how can I extract a unique list from another table to be used in another table?

For Example:

I have a table of sales and I want to get a unique list of the products that I have sold and I want to get a total of each product to be reflected in another view.

I need to extract the unique list on an existing table and use it in another table.

[jyothis_m]

Have you tried UNIQUE()

[Reji1234567]

It says that "Column Name 'ID' in Schema 'Actual Count_Schema' has a 'List' type. Only virtual columns are currently allowed to have the List type."

[jyothis_m]

You can make the column type to EnumList

[Reji1234567]

It says" Column Name 'PO' in Schema 'Actual Count_Schema' of Column Type 'EnumList' should have a list of allowed values or allow the user to add other values" I need to extract the unique list on a table and use it in another table.