Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have the following tables from a questionaire
table1
key person organisation mail Q1 Q2 Q3 Q4 Q5 Q6
01 xxx xxxxx xxx 0 1 2 1 2 1
02 xxx xxxxx xxx 1 2 1 3 2 1
03 xxx xxxxx xxx 1 0 3 1 0 0 etc
table2
keyquestion subject question
Q1 finance how .....?
Q2 finance how .....?
Q3 Human Resource how .....?
Q4 Human Resource how .....?
Q5 Service how .....?
Q6 service how .....? etc
table3
answer teXt
0 bad
1 average
2 good
3 perfect
Does anyone have an idea how to:
* connect the answers in table1 below Q1, Q2 etc to table3?
* connect the titles in table1 to table2?
I would like to make some graphs (for example) with a histogram of the scores for a single organisation and a specific subject. Anyone an idea? I can't find a similar question at this forum.
thanks in advance
Hi,
You need to use Crosstable(). Try this in your script:
Responses:
Crosstable(keyquestion,answer,4)
LOAD * FROM ResponsesData...;
Questions:
LOAD * FROM QuestionsData...;
Answers:
LOAD * FROM AnswersData...;
Hope this helps,
Jason
Hi,
You need to use Crosstable(). Try this in your script:
Responses:
Crosstable(keyquestion,answer,4)
LOAD * FROM ResponsesData...;
Questions:
LOAD * FROM QuestionsData...;
Answers:
LOAD * FROM AnswersData...;
Hope this helps,
Jason
Thanks Jason! The crossTable function works perfectly.
greetz
Perry