Forum Discussion
Solved
MATCH between 2 tables
Hello Community, I am trying to crease a measure using something similar to the MATCH function from excel. I have a table(1) that tells me which of the company's training modules my coworkers...
Another solution using Query Editor.
1. Left Outer Join
2. Conditional Column.
See the attached screenshots.
LEFT OUTER JOINEXPAND COLUMNCONDITIONAL COLUMNFINAL OUTPUT
You can use "LEFT OUTER JOIN" in Merge Queries in Query Editor to get the desired results.
It includes all the rows in the Courses table in the results, whether or not there is a match on the CourseID column in the Coursecompletionstatus table. Where there is no matching CourseID for a Course, the row contains a null value.