Forum Discussion
Add columns from one table to another
I have a table called Feedback with the many columns, however, I want to extract only a few columns into a new table
Following are the columns that need to be put in a new table
Question Text
Response Text
Date
Please tell me how this can be achieved? I tried using SELECTCOLUMNS but got an error saying that "got multiple values and expected single values"
Add a calulcated colum defined as RELATED(whatever the field is named in the related table)
b_minesh , refer this video how to copy value from one tbale to another
5 Replies
b_minesh , refer this video how to copy value from one tbale to another
Add a calulcated colum defined as RELATED(whatever the field is named in the related table)
When I use the RELATED function, the table that I want the column from does not show up.
Try the LOOKUPVALUE function
