My goal is to create a single report of classes taken for everyone from two different schools. I have two data sets, one from each school, that has username, course taken, status of course, and some other info.
My problem is not creating the report - I have my Tableau report completed and working with one school's data. My problem is now trying to add in the other data set. I want the data sets to be appended lengthwise, not widthwise.
Neither of the tables have any unique ID columns, and about 20% of the courses and users overlap.
A sample looks like this:
|Username||Course Name||Course Status||Course Date|
|userOne||Math 102||In Progress||2/13|
|User||Course||Status of Course||Grade|
|userThree||History 101||In Progress||36|
Again, I have my Tableau report set up and great with School A. I'm trying to add in School B. My goal is for Tableau to see one data set and just leave blank missing columns:
|Username||Course Name||Course Status||Grade||Course Date|
|userOne||Math 102||In Progress||null||2/13|
|userThree||History 101||In Progress||36||null|
Dropping the non-overlapping columns isn't ideal, but is something I can deal with if I need to:
|Username||Course Name||Course Status|
|userOne||Math 102||In Progress|
|userThree||History 101||In Progress|
I can't figure out how to do this. Everything I try - joins, unions, blends - tries to make an extended table widthwise and match columns together. I just want to be able to tell Tableau which columns are the same (e.g. username = user; course name = course; course status = status of course) and for Tableau to append one data set to the other.
Because the data sets will be live and continuously changing, I can't just do this by hand by copying and pasting one into the other.
I'm using Tableau Desktop, if it matters.
Any and all ideas are welcome. Thank you!