Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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"
Solved! Go to Solution.
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
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
Try the LOOKUPVALUE function
@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.