This content has been marked as final.
Show 2 replies
-
1. Re: Table join
Derrick Austin Dec 10, 2015 2:09 PM (in response to Mikey Michaels)1 of 1 people found this helpfulHey Mikey,
Depending on the data, you have two options to fix this issue.
A "LEFT JOIN" may solve the issue. A LEFT JOIN will keep data in the base table that does not have a matching record in the joined table.
W3 schools has a good explanation of this: SQL LEFT JOIN Keyword
If data in the base table AND data from the secondary table cannot be used as the "master list", you will need to do a subquery that does a SELECT DISTINCT on the customer for both datasources to get a "master list" that contains all of the customers. Then, simply LEFT JOIN in the measures from both tables.
Derrick Austin
InterWorks, Inc.
-
2. Re: Table join
Shanaka Gunaratna Dec 10, 2015 8:42 PM (in response to Mikey Michaels)1 of 1 people found this helpfulHi Mikey
Make the 'revenue' file to your primary data source and then left join with the 'software' file.