Forum Discussion

DarylRob's avatar
DarylRob
Icon for Helper I rankHelper I
4 years ago

Take distinct values from two different columns in two different tables and create a new table

Hi,    So I've got two tables both with Account Manager columns, for example   Table 1: Gary Gary Dave Terry Billy Billy   Table2: Jenny Jenny Dave Billy   And i want to then create...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

DarylRob , Create a new table

 

Name=

distinct(union(distinct(Table1[Name]),distinct(Table2[Name])))

  • DarylRob's avatar
    DarylRob
    Icon for Helper I rankHelper I
    4 years ago

    Perfect, thanks. But now i'm trying to create a relationship between the two fields but it won't create a many-to-one relationship instead only able to create a many-to-many. Any ideas?