I made a survey in the Sales Cloud that I am pulling into the Marketing Cloud using automation studio and the responses are saved in a data extension. However every question response appears as a different row. I am trying to use a SQL Query to join all responses from the same respondent into a new data extension. My query is as follows:
SELECT a.ResponseShortText firstquestion, b.ResponseShortText secondquestion, a.Id Id FROM Survey_Object_Import_Intern a INNER JOIN Survey_Object_Import_Intern b ON b.ResponseId = a.ResponseId
I created a data extension with 3 column names: firstquestion, secondquestion, Id. The syntax is valid, but when I run the query it does not do anything. (I selected the target data extension in the query activity in automation studio and selected append).