Add columns from one table to another

[b_minesh]

 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" 

[littlemojopuppy · Accepted solution]

Add a calulcated colum defined as RELATED(whatever the field is named in the related table)

[Icey]

Hi @b_minesh ,

Please let us know if the replies above are helpful.

If they are, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If not, please give us more details.

Best Regards,

Icey

[littlemojopuppy]

Try the LOOKUPVALUE function

[amitchandak · Accepted solution]

@b_minesh , refer this video how to copy value from one tbale to another

https://youtu.be/czNHt7UXIe8

[littlemojopuppy · Accepted solution]

Add a calulcated colum defined as RELATED(whatever the field is named in the related table)

[b_minesh]

When I use the RELATED function, the table that I want the column from does not show up.