Merged Queries not showing expected results

[Bharat_kumar]

Hi Team,

I have a requirement to merge two views in looker and its not working as expected. I want to understand how the looker joins these two views whether its based on column header names or column values.

Here is my example.

View 1 Category	Count
A	100
B	200
C	150

View 2 Category	Count
A	10
B	20

Expected Merge View:

Category	View 1 Count	View 2 Count
A	100	10
B	200	20
C	150	0

Actual Merge View:

Category	View 1 Count	View 2 Count
A	100	null
B	200	null
C	150	null

What is missing here? Does the merging feature expect the same number of records on both the views? Why its not able to join the records even though both the views have the category field.

@izzymiller
@cole_elliott