Forum Discussion
Post PatronComparing two tables, results return from only one
Step 1: You will need to create a reference to Table1 in query editor keep only the company column in it and remove duplicates (company name).
Step 2: You will need to create a reference to Table2 in query editor keep only the company column in it and remove duplicates (company name).
Step 3: Append the two referenced tables using 'Append Queries' and remove duplicates (company names)
Step 4: close and apply
Step 5: you need to now set relationship between Table 1 and Table 2 company name to the Appended Company name
step 6: build the visual by selecting the company name from Append table and Dates as a count from Table 1 and Table 2
Hope this helps you Have a Blessed day
This is happening because you don't have a table which has all the company names from table 1 and 2. If you are using import mode, I suggest you go to the query editor and use 'append queries as new' option. This will create a third table which you can use to pull data in your 'company' column. The idea is to have a table which contains all company names. Let me know if you have any doubts