Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
I posted a question about something similar recently, but I don't think I accurately captured the extent of the problem I'm having.
I have an app that pulls data from two different surveys, [WEBSurvey] and [SERVICESurvey]. [SERVICESurvey] has a field [Overall, how satisfied are you?] that contains values ranking satisfaction like so:
[Overall, how satisfied are you?] |
Very Satisfied |
Somewhat Satisfied |
Neutral |
Somewhat Dissatisfied |
Very Dissatisfied |
[WEBSurvey] has two fields, Question and Answer, that contain values ranking satisfaction like so:
Question | Answer |
How would you rate the quality of this website? | Excellent |
How would you rate the quality of this website? | Good |
How would you rate the quality of this website? | Satisfactory |
How would you rate the quality of this website? | Unsatisfactory |
How would you rate the quality of this website? | Poor |
Overall, I am satisfied with my experience | Strongly Agree |
Overall, I am satisfied with my experience | Agree |
Overall, I am satisfied with my experience | Neutral |
Overall, I am satisfied with my experience | Disagree |
Overall, I am satisfied with my experience | Strongly Agree |
The table [WEBSurvey] is linked to [SERVICESurvey] via two other tables with similar fields, like so:
[WEBSurvey], [Collectors], and [Responses] all extract their data from a Microsoft SQL Server, while [SERVICESurvey] gets its data from a REST connection.
Because the answers in the Answers field are similar to the possible values in the [Overall, how satisfied are you?] field, my client has asked me to make another field, AllSatisfactionRatings, that contains the following values:
AllSatisfactionRatings |
Very Satisfied |
Somewhat Satisfied |
Neutral |
Somewhat Dissatisfied |
Very Dissatisfied |
[test]:
Load * Inline [
"Overall, how satisfied are you?",Answer,AllSatisfactionRatings
Very Satisfied,Strongly agree,5 Very Satisfied
Very Satisfied,Excellent,5 Very Satisfied
Somewhat Satisfied,Agree,4 Somewhat Satisfied
Somewhat Satisfied,Good,4 Somewhat Satisfied
Somewhat Satisfied,Satisfied,4 Somewhat Satisfied
Neutral,Neutral,3 Neutral
Somewhat Dissatisfied,Disagree,2 Somewhat Dissatisfied
Somewhat Dissatisfied,Unsatisfactory,2 Somewhat Dissatisfied
Very Dissatisfied,Strongly disagree,1 Very Dissatisfied
Very Dissatisfied,Poor,1 Very Dissatisfied
];
[WEBSatisfactionRatings]:
Load
Answer,
AllSatisfactionRatings
Resident [test];
[SERVICESatisfactionRatings]:
Load
"Overall, how satisfied are you?",
AllSatisfactionRatings
Resident [test]
;
Drop table [test];
However, when I do that, this is the result: