Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Create a new table from 3 others

Hi,

I need some help, as subject says, in how to create a new table from the relation of 3 other tables.

Example: I have three tables, "StudentId", "Subject Name" and "Grade". And I want to create a new one with all students grade for a specific subject. It means.. instead of show Student ID's, this new table will show all student grades of, for example, Math subject.

Thanks in advance

5 Replies
deepakk
Partner - Specialist III
Partner - Specialist III

hi,

You can use join function, to get all three tables into one.

eg:

Load StudentID, Name, SubjectID,GradeID from Table1;

join

load SubjectID, SubjectName from table2;

join

Load GradeID, GradeName from table3;

Not applicable
Author

Can I use that join function on table (the new one) properties as an expression?

deepakk
Partner - Specialist III
Partner - Specialist III

hi,

You have to do it an script level. not on front end.

deepakk
Partner - Specialist III
Partner - Specialist III

hi,

If you want three tables data to be in one in front end then just link the three tables.

You have to make sure the field names are same to link it. The add the fields in Pivot or Straight or normal table.

Not applicable
Author

Ok, i'll try.

Thanks a lot 😉