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.
Have you tried UNIQUE()
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."
You can make the column type to EnumList
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.
User | Count |
---|---|
36 | |
31 | |
30 | |
20 | |
17 |