I created an Cairn Site and bootstrap-dashboards successfully.
In my case, I created a table student_school, have a relationship with user by school_id. I want create dataset of course_enrollments with user_school_id, how can I do that?
Without knowing student_school schema, its difficult to answer but let’s suppose we have user_id and school_id in student_school and want to create dataset by using course_enrollments and student_school, sql will look like:
SELECT ce.course_id, ce.user_id, ss.school_id as user_school_id
from course_enrollments as ce
JOIN student_school as ss on ss.user_id = ce.user_id
and click on Save Dataset
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.