Forum Discussion

moesteez's avatar
moesteez
Helper I
6 years ago
Solved

Joining two tables without filtering

Hi,   I feel like this should be easy but for the life of me cant seem to work it out.   I have two tables 'Employees' and 'Training'   Emplyees looks like: EmployeeID EmployeeName 1 G...
Need Help
  • MartynRamsden's avatar
    MartynRamsden
    6 years ago

    Hi moesteez 

     

    Click on the table visualisation and then, on the Visualisations pane, click the down arrow on 'EmployeeName'.

    Select the option to 'Show items with no data'.

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Your missing rows will then appear.

     

    Best regards,

    Martyn

     

    If I answered your question, please help others by accepting it as a solution.

MartynRamsden's avatar
MartynRamsden
Solution Sage
6 years ago

Hi moesteez 

 

Click on the table visualisation and then, on the Visualisations pane, click the down arrow on 'EmployeeName'.

Select the option to 'Show items with no data'.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Your missing rows will then appear.

 

Best regards,

Martyn

 

If I answered your question, please help others by accepting it as a solution.

  • yoavmor's avatar
    yoavmor
    Regular Visitor
    3 years ago

    this saved me from re-doing my entire 50-table report. thank you.