I have 2 queries in my report. 1 is a query imported from a local source (Query 1). The other query is imported from another dataset (Query 2).
I've created a many to one relationship between the unique ID numbers, which are common in both queries. The Unique ID may not necessarily be in 'Query 2'.
I have created a table in a report to show every line in 'Query 1', however, I want to add a column from 'Query 2' to this table. When I add this column, it removes the lines where those Unique IDs are not in Query 2.
How do I still keep those lines in Query 1 which do not have a link to Query 2, in the table visual, please? Just to show that particular cell as 'blank' in the table for the column I am adding from 'Query 2'
FYI - I have tried clicking the 'show items with no data' on the new column, but it 'errors' with too many lines being imported