Forum Discussion
pat_energetics
Advocate II
Advocate IISelectcolumns function
Hi all, Does anyone have any tips or examples on the use of the select columns function to create a new table. I'm trying to create a new table based on an extract of an existing one and their is l...
You can better use the query editor window and Duplicate/Reference an existing query in order to create a table with data from another table.
Hi pat_energetics,
if you want to extract some columns from a table to put them in another table you can use the SELECTCOLUMNS() function.
Here the neededarguments for the function:
and an example..
..let me know if it works.
#I'M Not An Expert#
charleshale
Continued Contributor
Continued ContributorI am getting an error message that "The expression refers to multiple columns. Multiple columns can not be converted to a scalar value". Isnt the point of the command to select multiple columns?