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).
a.Id
as a field, is that the same as ResponseID?