Forum Discussion

shefalinishad11's avatar
shefalinishad11
Helper I
5 years ago
Solved

Create unique table from two tables

Hi Team,   I am trying to create a new unique employee table with column, name id, name, rank, country. The two other tables are table1 & table2, both tables have the same 4 fields with the other 1...
Interesting Links
Need Help
Tips and Tricks
  • PoojaDarbhe's avatar
    PoojaDarbhe
    5 years ago

    Hi shefalinishad11 ,

     

    You can create a measure like below

     

    testcustomTab = DISTINCT(UNION(SELECTCOLUMNS(table1, "ID", table1[ID], "Name", table1[name]),SELECTCOLUMNS(table2, "ID", table2[id], "Name", table2[name])))
     
    Let me know in case of any help.
     
    Best regards,
    Pooja Darbhe
v-xiaotang's avatar
v-xiaotang
Community Support
5 years ago

Hi shefalinishad11 

 Have you solved this problem?

I create a sample, and you can take this for reference.

1. hit Append  Queries as New

2.remove unused columns

3.remove duplicates

Result:

 

Best Regards,

Community Support Team _ Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.