Use two different table for visualization

hi
I have two different table from data base that my IDs are in one of the tables and the names in the other . i wanna visualize the first one with the name in the other , how could i solve this ?

Hi @hoho94
I’m not sure if I understand what you’re asking for, but it sounds like you’re looking for “Display values” in Data Model:
https://www.metabase.com/docs/latest/administration-guide/03-metadata-editing.html#remapping-field-values
Otherwise you could create a View in your database, where you combine your tables, so Metabase just sees the end-product.

Hi @flamber
thanks for your response . I saw the link . actually i wanna make a table with columns of two different table . in the database model of metabase i can’t do that

@hoho94 Then you would just join the two tables via the Notebook Editor:
https://www.metabase.com/docs/latest/users-guide/custom-questions.html
Or create a view in the database, if you prefer that.