Match Pattern in variable
Can some one please suggest me a solution for my issue.
I have a report on survey which is pulling question from question table and answers and comments from answer table
As the Answers and comments are saved to the same table but under different answerID, they are displaying in the same column when the AnswerID is pulled in to the table.
But as per the requirement, I need to make sure that I get comments on the seperate column for corresponding answer.
I tried Match pattern on QuestionID but I experienced an issue where the Main question is disappearing from the table. Even though comments belong to the parent question, each comment is tied to ChildquestionID.
Plesae see the attached screenshot for further detail.