Forum Discussion

Belle2015's avatar
Belle2015
Icon for Helper II rankHelper II
1 year ago
Solved

Lookup to another table?

Hi, I have two tables, Table 1 has the Employee ID and Table 2 has the employee ID, expense type, value and transaction date. Some employees in table 1 may not have had an expense and be listed on ta...
Need Help
  • lbendlin's avatar
    lbendlin
    1 year ago

    Like this?

     

     

    Filters should ideally come from the dimension table. Your filter (Expense type) comes from the fact table.

     

    No need for a lookup, let the data model do the work for you

     

    showing and displaying  a 0 for any employees who dont have a company car expense

    Try not to do that, instead leave the row blank.

     

     

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
1 year ago

Like this?

 

 

Filters should ideally come from the dimension table. Your filter (Expense type) comes from the fact table.

 

No need for a lookup, let the data model do the work for you

 

showing and displaying  a 0 for any employees who dont have a company car expense

Try not to do that, instead leave the row blank.

 

 

  • Belle2015's avatar
    Belle2015
    Icon for Helper II rankHelper II
    1 year ago

    thank you, I got it, it was the relationship type 🙂 I was just over thinking it when it wasnt working!

  • Belle2015's avatar
    Belle2015
    Icon for Helper II rankHelper II
    1 year ago

    Hi, This is what I was trying to do at first and had it show as blank line for the employee's without expenses until I apply the filter for company car, once I apply the filter it does not show the employee ID's without a blank like