difficult to join with necessary duplicate values

[huixuan_tan]

Hi

I am stuck with this data set tables

Student info:

Admin Number	Name	Year of study
20001	Sally	2
20002	Tom	3
20003	Ashley	1
20004	Bernard	2
20005	Travis	2

Event info:

Attendance	Event ID	Event Name
20001	course002	Heartbeat
20003	course002	Heartbeat
20001	elective001	Spartan
20005	elective001	Spartan
20003	elective001	Spartan
20004	music004	Violin
20002	music004	Violin
20001	music004	Violin

My goal:  identify students who did not attend each activity by their admin number.

Issue: Duplicate admin number in attendance = cannot use join

Note: no hard coding allowed eg. wildmatch because there may be new programmes created in the future.

Please help:-) thank you so much:)

[Lisa_P]

Can you rename Attendance to [Admin Number] in the script ? This will associate these fields and give your results.

[huixuan_tan]

The attendance data has multiple programmes so a join wouldn’t do as there are duplicate admin numbers  but only 1 student info table 

[qlikerB96]

Hi,

Would you like to solve this problem in the script or in the visualization?

What Lisa_P said could be a correct way. If you give same names to two fields Qlik will make connection without any join. After this if you make two table charts (like in your post) and you pick a student you will see all the Events.

But if I understood well your post, you would like to have for example a new filed with a value 'OK', 'NOT OK' for each student and this value will depend on the attended events?

B.